Discussion Board for collaboration related to Creating Analytics for QlikView.
I load the following table (table A) and want it to convert to table B in the script of Qlikview.
I was thinking about the crosstable function but that doesn't work (with the knowlegde I have)
Does anyone has an idea?
Go to Solution.
Load *,Date(num("Start Date")+iterno()-1) as Date,
while num("Start Date")+IterNo()-1 <=num("End Date");
FROM Table A (Use Data Source path of Table A)
SET TimestampFormat='DD-MM-YYYY h:mm:ss[.fff] TT';
Load Item, Project, Quantity, Date([Start Date] + IterNo() - 1) as Date
While Date([Start Date] + IterNo() - 1) <= [End Date];
LOAD * Inline [
Item, Project, Quantity, Start Date, End Date
X, A, 1 ,01-09-2017, 05-09-2017
Y, A, 2 ,01-09-2017, 05-09-2017
X, B, 2, 02-09-2017, 04-09-2017
Many thanks Shraddha and Anil.
How does iterno work?
Google it !!
Refer IterNo - script function ‒ Qlik Sense