Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need to create the following;
Dimension (displayed) - country
Measure (displayed) - number of days
Measure (hidden) - number of sales
The number of sales measure should not be shown but the chart needs to only pick up the top 4 countries by number of sales and display the number of days for those countries. Right now I can only select the top 4 by number of days.
Please can you help.
Thanks,
Kizzy
Happy to help; please close the thread by marking a correct response
Qlik Community Tip: Marking Replies as Correct or Helpful
Hi Vineeth,
The measure works but shows all the countries which are not in the top 5 (see screen shot). I don't want to see these. I tried using the AGGR dimension you provided as this looks like it will fix the issue but couldn't get the it to work as it was only delivering 1 column. Please could you help.
Thanks,
Kizzy