Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
acholchemit
Contributor II
Contributor II

Use same Top 10 limit in a chart for the main and alternative measure

I have a chart and I would like to show two measures main and alternative but use the same Limit totals for both measures.

The measures would be

1. Total measure value (The limit total is based on this measure)

2. Average measure value

The effect would be we see the same Customers and be able to swap between the measures.  In my chart this isnt working when I choose the alternative measure it loses the top 10 ranking and so shows a different set of Customers.

Is this possible?

 

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

HI 

the built in top function always use the active dimension 

for your requirement you can use a calculated dimension 

aggr(if(rank(Total measure value)<=10,CustomerName),CustomerName)

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

HI 

the built in top function always use the active dimension 

for your requirement you can use a calculated dimension 

aggr(if(rank(Total measure value)<=10,CustomerName),CustomerName)

acholchemit
Contributor II
Contributor II
Author

Worked like a charm, thankyou.