Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mkelemen
Contributor III

Re: Display only top N% by Calculated Measure (Qlik Sense)

You're right, I forgot that it is qlikview only.
What you can do is put the limitation directly into expressions.
Check the example - you can select the dimension and the result is only <=50% of Sum() of the selected dimension. I have it hardcoded but you can use variable. Disadvantage is that it also needs to be sorted by the same dimension because it uses Above().
BR,

  Matus

Not applicable

Re: Display only top N% by Calculated Measure (Qlik Sense)

Matus,

For some reason I am not able to see any attached file in your reply. Can you please double check form your end.

mkelemen
Contributor III

Re: Display only top N% by Calculated Measure (Qlik Sense)

Let's try again.

MVP
MVP

Re: Display only top N% by Calculated Measure (Qlik Sense)

Highlighted
Not applicable

Re: Display only top N% by Calculated Measure (Qlik Sense)

That example is perfect in Qlik View. But in Qlik sense the Limitation option is quite rigid in terms of using 1st measure only.

Thanks!!

HK

mkelemen
Contributor III

Re: Display only top N% by Calculated Measure (Qlik Sense)

This example is in sense and it does not use Limits.

  Matus