Skip to main content
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 ....

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