topic Re: Rolling 12 months in QlikView

Rolling 12 months

Thu, 29 Aug 2013 15:28:12 GMT

I am confused!

I am trying to make a chart that shows the number of visits over the course of the last 12 months. My expression works until I include the 12 month piece....

count({<[Appt Arrived Flag]={1}, [BHN Dept Name]={'Health Centers'},Month={'>=(Date(floor(max(Month))-365))'}>}CountAppt)

If I take the expression:

=Date(floor(max(Month))-365)

and put it into a text box, it works! (I get 8/1/2012)

But when I add it as part of the set analysis I get NOTHING!

Re: Rolling 12 months

Thu, 29 Aug 2013 15:33:20 GMT

Nevermind... I answered my own question 2 minutes after I posted it!

count({<[Appt Arrived Flag]={1}, [BHN Dept Name]={'Health Centers'}, [Appt Datetime]={'>=$(=Addmonths(max([Appt Datetime]),-12))'}>}CountAppt)

Re: Rolling 12 months

MayilVahanan — Thu, 29 Aug 2013 15:33:23 GMT

=Date(floor(max(Month))-365) gives date.

So you map with date in set analysis , not with month

count({<[Appt Arrived Flag]={1}, [BHN Dept Name]={'Health Centers'},DateField={'>=$(=AddYears(Max(DateField),-1))'}>}CountAppt)

Hope it helps

Re: Rolling 12 months

Thu, 29 Aug 2013 15:34:26 GMT

Hi,

Try this :

<month={"<= $(=date(floor(max(month())-365)) "}>

Regards

DAAM