topic Re: Problem with set analysis restricting months in QlikView

Problem with set analysis restricting months

Fri, 29 Nov 2013 18:18:35 GMT

I have a Set Analysis showing the last 3 months according to what the user selected month, if I select October, the chart shows

data for July, August and September, the correct is August, Setember and October. Follows the current formula:

num( Sum({$<Calendar.Month={'>=$(=max(Calendar.Month-3))<=$(=max(Calendar.Month))'} Table.Value) '#.##0M')

Fri, 29 Nov 2013 18:34:02 GMT

for previous 3 month data try this

sum({<Datefieldname={">=$(=monthstart(max(Datefieldname),-3))<=$(=monthend(max(datefieldname),-1))"}, year=,month=>}TableValue)

Fri, 29 Nov 2013 18:38:13 GMT

or try this

num( Sum({$<Calendar.Month={'>=$(=max(Calendar.Month-2))<=$(=max(Calendar.Month+1))'} Table.Value) '#.##0M')