Discussion board where members can get started with Qlik Sense.
I have to calculate the max value of the following exspression but in sense it's not possible to use nested aggregation, how can I solve it?
(month(DateCalendar)<=Month(vDateSet) and year(DateCalendar)=year(vDateSet)
or month(DateCalendar)>=Month(vDateRolling) and year(DateCalendar)=year(vDateRolling))
Thanks in advance for helping
Nested aggregation? What are you trying to do? May be provide a sample with expected output