Creating a reference line to highlight the Top 5 Countries
In this video we explore the process of crafting a dynamic bar chart to spotlight the top 5 countries based on sales data in Qlik Cloud.
Discover professional customization options, such as concealing country names and enhancing the title with colored backgrounds, to ensure clarity in your visualizations.
00:00 - Intro
00:15 - Creating the bar chart
00:44 - Using a Set Analysis expression to filter the data
1:03 - Customizing the reference line
The video will show you also some example of usage of the Qlik functions:
Only: that restrict the possible values of a field to a single value.
Rank: that Ranks the data of the Sum of Sales for each Country
Set analysis: in conjunction with the Rank function, it selects countries where the sum of sales ranks as the fifth highest.