Accéder au contenu principal

Changing the sorting of a visualization using expressions

Miniature de la vidéo
In this video, you'll learn how to customize the sorting order of dimensions and measures in Qlik Cloud Analytics. While default sorting may not always display your data in the most useful way, Qlik provides flexible options to enhance your visualizations. We'll show you how to access the sorting section in the properties panel and explore different sorting methods, such as alphabetical order or sorting by expression. Watch as we demonstrate how to create a custom order for the region field using an if function statement, ensuring the USA appears first, followed by Germany, the UK, Spain, the Nordic countries, and Japan. This method is particularly useful for highlighting regions with the largest markets or other key priorities. By the end of this video, you'll know how to tailor your visualizations to present data exactly the way you need it. Function used in this example: If Function if(Region='USA', 1, if(Region='Germany',2, if(Region='UK',3, if (Region='Spain',4, if (Region='Nordic',5, if(Region='Japan',6))))))