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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

display N top value in straight table

I looking for a best idea to show more than 100 top values in straight chart (maybe slider or an input field with variable)

check posted sample file ....

Labels (1)
1 Solution

Accepted Solutions
Not applicable
Author

Use this as your dimension

=aggr(if(rank(sum([SPR CSN]))<=100,Nazwa),Nazwa)

View solution in original post

5 Replies
Not applicable
Author

....or a quick macro exporting first N rows from this chart to excell....

whiteline
Master II
Master II

In QV 11  you can use dimension limits.

You can use expression or variable.

Not applicable
Author

i've got QV10

Not applicable
Author

Use this as your dimension

=aggr(if(rank(sum([SPR CSN]))<=100,Nazwa),Nazwa)

Not applicable
Author

perfetto mi amigo:P