Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: display N top value in straight table

Use this as your dimension

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

5 Replies
Not applicable

Re: display N top value in straight table

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

whiteline
Honored Contributor II

Re: display N top value in straight table

In QV 11  you can use dimension limits.

You can use expression or variable.

Not applicable

Re: display N top value in straight table

i've got QV10

Not applicable

Re: display N top value in straight table

Use this as your dimension

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

Not applicable

Re: display N top value in straight table

perfetto mi amigoSmiley Tongue

Community Browser