Data period flag

Anonymous — Wed, 25 Jun 2014 11:57:14 GMT

Good Day!

Need help for making flag in script to get dynamically some period

i have field with years (...2013,2014)

field with monthName(....Apr,May,Jun)

what must i write in script to make some flag, which will get dynamically period from March this year to October last year?

Thank you!

Re: Data period flag

tresB — Wed, 25 Jun 2014 12:52:50 GMT

May be like:

Load

Year,

Month,

If(Date#(Year&Month,'YYYYMMM')>=Date#('Oct'&(Year(Today())-1), 'MMMYYYY') and

Date#(Year&Month,'YYYYMMM')>=Date#('Mar'&(Year(Today())), 'MMMYYYY') , 1,0) as Flag

From <>;

This is just an idea. You can make it more dynamic and might have to adjust it accordingly. Hope this helps. Or the same can by done using a preceding load with less complex expression.

topic Re: Data period flag in QlikView

Data period flag

Re: Data period flag