topic Re: Script in QlikView

Script

mario-sarkis — Mon, 01 Jun 2015 12:36:17 GMT

hey all

i need your help

how can i write in a script

PeriodDate > one year back (noting that periodDate is a number)

and my request is if i am in 15 of april 2015 i need my PeriodDate become Greater in 1 of april 2014 not 15 of april .

Hope you can help thanks.

Regards,

Re: Script

sunny_talwar — Mon, 01 Jun 2015 12:43:58 GMT

Not sure if you are using this in if statement or where clause, but the basic idea for checking should be something like this, if you are checking it against one year back from Today:

MonthStart(Date(PeriodDate)) > AddYears(Today(), -1)

Slight update: Date(PeriodDate) > AddYears(MonthStart(Today()), -1)

HTH

Best,

Sunny

Re: Script

alexandros17 — Mon, 01 Jun 2015 12:51:46 GMT

There are lots of Date time functions, MonthStart() set the starting day of the month starting from a date, you can use it for your problem