Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])
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.
Look at HIC's response here https://community.qlik.com/t5/New-to-QlikView/Why-i-am-not-getting-same-result-with-Above-function/m...