Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Matus,
For some reason I am not able to see any attached file in your reply. Can you please double check form your end.
Let's try again.
Open this link to see the attachment
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
This example is in sense and it does not use Limits.
Matus