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

[#1]

Hello Qlik gurus,

I have a requirement to show only top % of of the records in a table based on a calculated measure Sum(Units)/ Sum(Total Units). It might be trivial but I did search for it in all the forums with no luck.

Thanks in Advance

H.K

[mkelemen]

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

[#3]

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]

Let's try again.

[sunny_talwar]

Open this link to see the attachment

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

[#6]

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]

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

  Matus