Qlik Sense | Converting LODs to Set Analysis

[AnkitMadhukar]

Hi Everyone,

I am in the process of migrating one report from Tableau to Qlik Sense.
The requirement is to calculate average of Amount at day , week and month level (in different expressions)

An example of the expression used in Tableau

Avg({INCLUDE [AccountID],DATEPART('month',[TransTime]),DATEPART('year',[TransTime]): Sum([Amount])})

The above expression gives me an average by month.
How can I achieve this in Qlik?

Best Regards,
Ankit 

[Chanty4u · Accepted solution]

can you try this?

Avg(Aggr(Sum(Amount), Month, AccountID)

[AnkitMadhukar]

Hi @Chanty4u ,
Thank you so much!!

Sorry for the late response.
Currently, I am unable to access the data source for some reason.
Will check and update it once I try this.

One query that pops up is aggr will be executed at run time which can slow down the report ( I have around 50M records) , and aggr is not supported in the data load script.
I am trying to create these tables in the data layer itself to improve performance.

Best Regards,
Ankit Madhukar

[AnkitMadhukar]

Hi @Chanty4u , 
Thank you so much!! .
Its working now , will make few changes to make it work for the actual data.
Thanks