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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
johndemars
Contributor II
Contributor II

Change measure limitation

Hi, 

I have a table with customers with 3 columns, net 2021, net 2022 and 2023 in that order. I want a limitation of top-20 customers based on 'net 2023'. Automaticly Qlik takes the first column (net 2021) to do the calculation, how can i change it? Or is there a formula?

Tnx

John

johndemars_0-1675936765681.png

 

Labels (2)
1 Solution

Accepted Solutions
ogster1974
Partner - Master II
Partner - Master II

Reorder your columns it will always take it in the first measure.

 

View solution in original post

2 Replies
ogster1974
Partner - Master II
Partner - Master II

Reorder your columns it will always take it in the first measure.

 

vasilev
Creator
Creator

 There is a feature suggestion in the ideation platform. You can vote for this issue to push it in the roadmap.

https://ideation.qlik.com/app/#/case/274396?currentProductId=9da99bc1-0dfb-4471-8e12-d23685578c43&se...

BR,

Rumen