Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following formular:
sum({<Person={"=sum(Amount)>=$(=max(aggr(sum(Amount),Person),3))"}>}Amount)
It gives the sum of the the amounts of the 3 people with biggest sum(amounts) and works fine for a small testdataset.
However, when I use it for a large dataset (which also contains larger values) it outputs 0.
Has anyone an idea why this is the case or how to fix this?
max(aggr(sum(Amount),Person),3) still works fine in the large dataset.
Thank you!
Or is is it possible that the format of the rawdata (which comes from an Excel-file) causes this?
Hi Michael,
First and foremost, Qlik's engine uses the memory 4 times than the actual size of the data. hence calculation uses remaining.
In the formula you mentioned, here is my comments:
sum({<Person={"=sum(Amount)>=$(=max(aggr(sum(Amount),Person),3))"}>}Amount)
The sum of amount is being calculated a lot of times than it is required. You can assign a variable and have the value available for you to use in such complex set analysis statements.
variable SumAmount=sum(Amount);
The statement now becomes more easy as sum({<Person={"=SumAmount>=$(=max(aggr(SumAmount,Person),3))"}>}Amount)
Let me know if it works for you.