Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Mehtab
Contributor
Contributor

sum of sales on the max available date of each month

I am trying to find out the sum of sales on the max available date of each month.

i am using the below set analysis:

SUM({<[Date]= {"=Aggr(max([Date]),[Month])"}>}[Sales])

the above expression returns the sum of sales on the first day of each month

even though Aggr(max([Date]),[Month]) returns the correct max available date of each month.

Please help

 

 

Labels (1)
15 Replies
sunny_talwar

How about this?

Sum({<[Date] = {"=[Date] = Aggr(NODISTINCT Max([Date]), [Month])"}>} [Sales])

or this

Sum({<[Date] = {"=[Date] = Aggr(Max(TOTAL <[Month]> [Date]), [Month], [Date])"}>} [Sales])
Mehtab
Contributor
Contributor
Author

@sunny_talwar
The first expression worked.
Thank you so much for the help.
Really appreciated!!
Mehtab
Contributor
Contributor
Author

@sunny_talwar
Could you please explain this logic?
It will help alot if we face similar situation
sunny_talwar

Can you be specific as to what you do not understand about the expression? I will be able to explain better if I know what you need help with.

Mehtab
Contributor
Contributor
Author

Why are we using "=Date=" again within the quotes?