Set Analysis Help

tchovanec — Thu, 14 Jun 2012 18:57:55 GMT

I am trying to show results from the previous completed month minus 1 year back. So I would like to get data from 05/2011 - 05/2012. Below is my expression, but it only returns the current months data, so 06/2011-06/2012. Any hep would be apprecaited.

SUM

({<CAL_CENSUS_DT.Date={"<= $(=MAX(CAL_CENSUS_DT.Date)) >=$(=ADDMONTHS(MAX(CAL_CENSUS_DT.Date),-12))"},PT_CLASS={1,114}>}PT_DAY_COUNT

)

Re: Set Analysis Help

chematos — Thu, 14 Jun 2012 20:13:40 GMT

SUM

({<CAL_CENSUS_DT.Date={"<= $(=addmonths(MAX(CAL_CENSUS_DT.Date),-1)) >=$(=ADDMONTHS(MAX(CAL_CENSUS_DT.Date),-13))"},PT_CLASS={1,114}>}PT_DAY_COUNT

)

topic Re: Set Analysis Help in QlikView

Set Analysis Help

Re: Set Analysis Help