topic Qlik Sense set analysis for large data sets in App Development

Qlik Sense set analysis for large data sets

Fri, 24 Apr 2015 06:31:20 GMT

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!

Re: Qlik Sense set analysis for large data sets

Fri, 24 Apr 2015 15:52:03 GMT

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

Re: Qlik Sense set analysis for large data sets

Tue, 11 Jul 2017 14:37:28 GMT

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.