topic Re: Previous month not working - Set analysis in QlikView

Previous month not working - Set analysis

Thu, 07 Nov 2013 17:28:08 GMT

hi i am attempting to show the previous month here, however it is not working according to plan.

the syntax seems correct however, so not sure if there is an underlying problem in the data.

any help would be greatly appreciated.

Best

Brad

=Count({$< inLeveransDatumMonth = {$(=Max(inLeveransDatumMonth)-1)} >}

(Inlev_Radnummer))

Gysbert_Wassenaar — Thu, 07 Nov 2013 17:40:57 GMT

Your month field isn't a number, but a dual value. That complicates things. One way is to use this expression:

count({<inLeveransDatumMonth={'>=$(=max(inLeveransDatumMonth)-1)<=$(=max(inLeveransDatumMonth)-1)'}>}Inlev_Radnummer)

You could also create a numeric month field in the script and use that instead: autonumber(monthstart(MyDate),'MonthSerial') as MonthSerial

Anonymous — Thu, 07 Nov 2013 17:53:13 GMT

Unless there is a valid reason to use set analysis, this can work:

=Count(if(inLeveransDatumMonth = Max(all inLeveransDatumMonth)-1, Inlev_Radnummer))

Thu, 07 Nov 2013 18:55:51 GMT

this actually works, really cool i can perhaps use it in other places, thanks Michael your a star!