Discussion Board for collaboration on QlikView Scripting.
I have a downtime and uptime dates now i want generate dates between them in a date format. If field1 is less than filed2 i need to display all the dates in between them. I'm attaching the attachment of input data and output. Please help me......
I think you need IntervalMatch functionality. Look here: IntervalMatch
You can using while like below
TimeStamp(Floor(Field1 + IterNo() -1)) AS NewFieldName
WHILE (Field1 + IterNo() - 1) <= Field2;
Hope this helps you.
Thanks ur replies both queries are working fine......
Glad we were able to help. Please close the thread by marking Correct and Helpful answers (if any)