topic Previous Month from Today in QlikView

Previous Month from Today

azmeerrehan — Tue, 01 Aug 2017 02:06:18 GMT

I have a requirement where I don't have a filter for Year and Month and the date fIeld is 'YYYYMM'. By default the report shows the data for the current month. The expression is a set analysis. Its working fine, until you hit the 1st of the month. So on the1st of Aug for example I still have the data loaded for Jul 31st and no Aug Data yet. So the report will show 0 cuz month(T0day()) is Aug and there is no data for Aug. I am trying to build a logic like (If(Day(Today()>1, Month(Today()), Month(Today())-1 for previous MOnth.

What am I doing wrong here ??

Re: Previous Month from Today

sunny_talwar — Tue, 01 Aug 2017 02:15:51 GMT

May be this

If(Day(Today()) > 1, Month(Today()), Month(Today() - 1))

Re: Previous Month from Today

azmeerrehan — Tue, 01 Aug 2017 02:18:55 GMT

Doesnt work, but was able to get this work

=If(day(Today())>1,Month(Today()),dATE(Date(Today(),'YYYYMM')-1,'MMM'))

Re: Previous Month from Today

sunny_talwar — Tue, 01 Aug 2017 02:22:05 GMT

Strange, but okay