Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
uko223
Contributor III
Contributor III

Trying to Rank on a measure that is not visible on a pivot

Hello,

I have a pivot table that shows top 10 upward trends for customers based on 4 QTRS. the upward trend is a expression that I want to drive the results behind the scenes, I don't want the upward column on the table. That is fine for sorting as I can do so by the expression, but I am having a hard time only displaying the top ten with out the column there. Currently, I am using dimension limits, but that's contingent on the upward measure next to the dimension. I was thinking the rank function, but am not sure how to apply it here.

Any help/suggestions would be great!

1 Reply
rupamjyotidas
Specialist
Specialist

Maybe This

Sum({<Upward={"=rank(Upward)<=10"}>}Currrent QTR)