Discussion Board for collaboration on QlikView Scripting.
I have company and department and from & To date wise target data. I have to create a single date. I have posted a demo data in excel and the the desired output in the excel and also a qvw app. Please check & revert if anyone have any solution.
Go to Solution.
See if this script helps:
(ooxml, embedded labels, table is Data);
Load min(DateFrom) as minDate,
max(DateTo) as maxDate
Let varMinDate = Num(Peek('minDate', 0, 'Temp'));
Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));
DROP Table Temp;
LOAD Date($(varMinDate) + IterNo() - 1) as Date
While $(varMinDate) + IterNo() -1 <= $(varMaxDate);
I think you will find IntervalMatch useful here: IntervalMatch
Check this link. Hope this will help you.
Creating a Date Interval from a Single Date
Interval Match Feature/Function
Date(DateFrom+IterNo()-1) as Date
From <> While DateFrom+IterNo()<=DateTo;