Discussion board where members can learn more about Qlik Sense App Development and Usage.
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:
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.
It gives the sum sales on the max date of the max month.
However i need the sum of sales on the max date of all the month.
I need to make a master measure like that .
Hence when put against any dimension it should give the sum of sales on the max date of each month for that dimension
My bad. I didn't realise what you wanted. Set analysis is calculated once per chart so taht's obvious.
your expression shall work, i tried it.
What dimension are you using? I tried with similar sample data and it's working for me.