Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
mahitham
Creator II
Creator II

Set analysis help

Hi Experts,

Can any one please help me on below requirement.

I have build Monthly Trend chart in the below image with expression

=Sum(Aggr((Sum({<Type={'A'}>}Amount)*Avg(A1%)),Date,Dept,Branch))

This chart contains Monthly Total Amount.

In the second chart i.e., Monthend Trend need to show each month Max(Date) Total amount in the trend instead of all the dates Total Amount in each month.

I have tried below expression for only Monthend Trend in each month

=Sum(Aggr((Sum({<Type={'A'},Date={'$(=Date(Max(Date),'DD/MM/YYYY'))'}>}Amount)*

Avg({<Date={'$(=Date(Max(Date),'DD/MM/YYYY'))'}>}A1%)),Date,Dept,Branch))

But only Sep Month Max(Date) Total amount getting correctly remaining months showing Zero values.

Please help on this.

Thanks in advance.

10 Replies
mahitham
Creator II
Creator II
Author

Thanks a lot tresesco

Its working.