Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Architect
Partner - Creator
Partner - Creator

Select Top % Dimension based on Measurement in Filter Pane

Data be like-

DIM1 sales
A 12
B 11
C 32
A 22
C 21

Hi,

I need to Find out top 2 Dimensions based on the Sales (sum(sales)). and need to show these two top Dimensions.

Top 2 Dimensions
A
C

 

Labels (1)
1 Reply
randomuser
Partner - Contributor
Partner - Contributor

Hi,
You can try use this expression =if(aggr(rank(sum(sales)),dim1)<=2,dim1) on data dimensions in filter pane.

Regards