topic Re: Current month and two previous months in QlikView

Current month and two previous months

stekol61 — Fri, 01 Sep 2017 08:16:53 GMT

Hi!

I have an OnOpen trigger as "=Num(Month(Today()), '00')".

This gets the current month when the report id opened.

I want to have current month and the previous 2 months instead, e.g. Sep, Aug and July

How to do this?

tresB — Fri, 01 Sep 2017 09:29:09 GMT

May be this:

='(' & Num(Month(Today()), '00') &'|'& Num(Month(Today())-1, '00') & ')'

antoniotiman — Fri, 01 Sep 2017 09:30:36 GMT

Hi Stefan,

try this

='>='&Num(Month(AddMonths(Today(),-2)))&'<='&Num(Month(Today()))

Regards,

Antonio

stekol61 — Fri, 01 Sep 2017 10:16:33 GMT

This works fine.

Thank You