Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
AnkitMadhukar
Creator
Creator

Qlik Sense | Converting LODs to Set Analysis

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 

Labels (1)
1 Solution

Accepted Solutions
Chanty4u
Champion III
Champion III

can you try this?

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

View solution in original post

3 Replies
Chanty4u
Champion III
Champion III

can you try this?

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

View solution in original post

AnkitMadhukar
Creator
Creator
Author

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
Creator
Creator
Author

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