Discussion Board for collaboration on QlikView Scripting.
Hi Friends Stuck with Date Functions,I Have a Shipping Period Field with all Dates the Format is
1)How to get into YYYYMM like 201406
2)We will store data in separate QVD for each year based on business requirement
How to get past 12 months of data from current date,my problem is if i have all data in one qvd i have written as follow
Where [Shipping Period]>=$(vPrevious) and [Shipping Period]<=$(vCurrent)
How to check Different QVD and Get data from current date.
Suppose need to see date of Today() to previous 12 months of Date
Nov-2014 to Nov-2013 here need to compare 2 Qvds
1) Just an example =DATE(Today(),'DDMMYYYY')
Not Expecting in this way how to change below format of
to YYYYMM as 201406
2)how to get past 12 months of data from qvd where for each Year 1 Qvd how to get data in a loop.
2) If you have not really big qvd you can use just *.qvd (qvd) instead of actual file name,
If they are big you just need to calculate years and put variable as filename.
For i=$(vCurrentYear)-1 to $(vCurrentYear)
FROM $(i).qvd (qvd)
WHERE [Shipping Period]>=$(vPrevious) and [Shipping Period]<=$(vCurrent);