Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Date generating problem

Hi bro,

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......

Tags (1)
4 Replies

Re: Date generating problem

I think you need IntervalMatch functionality. Look here: IntervalMatch

HTH

Best,

Sunny

MVP
MVP

Re: Date generating problem

Hi,

You can using while like below

LOAD

ID,

Field1,

Field2,

TimeStamp(Floor(Field1 + IterNo() -1)) AS NewFieldName

FROM DataSource

WHILE (Field1 + IterNo() - 1) <= Field2;

Hope this helps you.

Regards,

Jagan.

Not applicable

Re: Date generating problem

HI sunny/Jagan

Thanks ur replies both queries are working fine......

Re: Date generating problem

Awesome

Glad we were able to help. Please close the thread by marking Correct and Helpful answers (if any)

Best,

Sunny

Community Browser