Discussion Board for collaboration on QlikView Scripting.
I need your help to retrieve the last 6 months record from the existing qvd file. Please find below sample.Thanks.
where submittedon>=currentdate-6 months
Go to Solution.
Try the below code .
where fabs( submittedon)>=fabs(Addmonths(Toda(),-6)) ;
So what about your sample script ..it seems right .
Load * from xyx where Date >= addmonths(today(),-6);
this will give exact last 6 month data meaning if today is 12th July 2013 then it will give data from 12th Jan 2013.
If you need data from 1st Jan 2013 that is last 6th months start date. then try below
Load * from xyx where Date >= monthstart(addmonths(today(),-6));
where submittedon>= date(addmonths(today(),-6),'DD/MM/YYYY')
make sure that submittedon and date(addmonths(today(),-6),'DD/MM/YYYY') should have date format.
Hope it helps you
where submittedon>=TODAY()- month(6)
Check this Condition
(ooxml, embedded labels, table is Sheet1)
Where Date >= addmonths(monthend(today()),-7) and Date < monthstart(today());
Thanks all for your kind reply. I am now able retrieve the last 6 months by using
fabs( submittedon)>=fabs(Addmonths(Toda(),-6)) ;