Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kizzydavies
Creator
Creator

How can I have a bar chart that displays 1 measure but is limited by another

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

Qlik Bar Chart.png

11 Replies
vinieme12
Champion II
Champion II

Happy to help; please close the thread by marking a correct response

Qlik Community Tip: Marking Replies as Correct or Helpful

kizzydavies
Creator
Creator
Author

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

QLIK Rank screen shot.PNG