topic Re: 6 months to date in QlikView

6 months to date

Mon, 01 Dec 2014 06:14:31 GMT

Hi All

I'm trying to write in my script a quick date value- ' 6 month to date'

I add other values that I am using in my calender like the following quick dates:

example for this week:

load

fulldate,

'this week' as quickdate

Resident Calendar

where fulldate>= WeekStart($(vToday))

and FullDate <= $(vToday);

so how can I calculate 6 months to date??

I really appreciate your help

Thanks in advance!

sushil353 — Mon, 01 Dec 2014 06:20:12 GMT

Hi,

do you want to get past six month data in script loading or in expression in chart.

in either case you can use Addmonths() function to go back 6 month back.

for example : Addmonths(datefield,-6)

HTH

Sushil

Mon, 01 Dec 2014 06:59:00 GMT

Thank you so much!