topic Re: Display Top N Values in QlikView

Display Top N Values

Anonymous — Mon, 28 Mar 2016 16:04:44 GMT

Dear Experts,

Need your help to resolve problem to display top 10 values in a line chart (which is achievable using dimension limits) but doing so chart always displays top 10 irrespective of the number of values selected in dimension field.

My requirement is to show top 10 by default but if more than 10 dimension values are selected chart should be displayed for all the values.

My chart is having two dimensions (Month and Name) and one measure (count distinct).

Any help in this is highly appreciated.

Regards,

Re: Display Top N Values

sunny_talwar — Mon, 28 Mar 2016 16:05:57 GMT

What is the expression you are currently using? Do you have a sample you can share?

Re: Display Top N Values

swuehl — Mon, 28 Mar 2016 16:54:08 GMT

Try something like

=If(GetSelectedCount( Name ) <=10,

Count({<Name = {"=Rank(Count(DISTINCT Field))<=10"}>} DISTINCT Field),

Count(DISTINCT Field)

)

and disable the dimension limit option. You almost for sure need to adapt the set expression / rank function to use the correct measure for ranking. If you need more help on this, please post a small sample QVW, as Sunny suggested.

Re: Display Top N Values

Anonymous — Mon, 28 Mar 2016 20:33:01 GMT

Hi Sunny,

Thanks for taking time to reply to my question but solution given by Swuehl worked and I am getting the required chart with that.

Regards,

Re: Display Top N Values

Anonymous — Mon, 28 Mar 2016 20:34:22 GMT

Hi Swuehl,

Thanks for your reply and your solution worked and desired output is achieved.

Appreciate your time on this.

Regards,