Discussion Board for collaboration related to QlikView App Development.
Not a QlikView developer at all so I am seeking assistance on how I can create a date range that begins on the last 3 days of a specific month?
Bigger Picture :
I am trying to automate a load on my QV report but there are two sources and it varies which source to load depending on the date.
Ex. If the DATE is equal to the last 3 days of February to 14th of March
Load from: Datasource2
Load from: Datasource1
You can achieve this by using the script below, it is just an example you can modify as per your need
For i = -3 to 13
Table:LoadDate(Num(Monthstart(Addmonths(Today(),-1)))+$(i)) AS DateAutoGenerate 1;Next ;
Today()-2 AS Date, If(Exists(Date,Today()-2),'Yes','No') As CondAutoGenerate 1;
Let vCondition = Peek('Cond',0,Table2);
if vCondition = 'Yes' then
Load'Yes' AS DataAutoGenerate 1;
Load'No' AS DataAutoGenerate 1;
Let me know in case of any difficulty