Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
Not applicable

Qlik Sense set analysis for large data sets

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!

2 Replies
Not applicable

Re: Qlik Sense set analysis for large data sets

Or is is it possible that the format of the rawdata (which comes from an Excel-file) causes this?

Not applicable

Re: Qlik Sense set analysis for large data sets

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.