topic Re: Rolling twelve month in QlikView

Rolling twelve month

Mon, 10 Sep 2012 14:58:40 GMT

Hi,

I need to use a calculation in a chart with YearMonth as dimension and a datefield StockDate (YYYYMMDD). I trying to use following expression but it relly doesn't work.

count({<StockDate ={">=$(=Date(addmonths(monthend(Max(StockDate), -12), 'YYYYMMDD'))) <=$(=Date(addmonths(Max(StockDate), -1), 'YYYYMMDD'))"}, GroupID= {'North'} >} CustomerRoID)

Any one that have any suggestions?

Re: Rolling twelve month

whiteline — Mon, 10 Sep 2012 18:22:10 GMT

Try to correct the brackets:

=count({<StockDate ={">=$(=Date(addmonths(monthend(Max(StockDate)), -12), 'YYYYMMDD'))) <=$(=Date(addmonths(Max(StockDate), -1), 'YYYYMMDD'))"}, GroupID= {'North'} >} CustomerRoID)

Re: Rolling twelve month

MayilVahanan — Mon, 10 Sep 2012 18:39:11 GMT

Try like this

count({<StockDate ={">=$(=Date(monthend(addmonths(Max(StockDate), -12)), 'YYYYMMDD'))<=$(=Date(Monthstart(addmonths(Max(StockDate), -1)), 'YYYYMMDD'))"}, GroupID= {'North'} >} CustomerRoID)

Hope it helps