topic Re: Date generating problem in QlikView

Date generating problem

Wed, 19 Aug 2015 14:38:13 GMT

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

Re: Date generating problem

sunny_talwar — Wed, 19 Aug 2015 14:41:21 GMT

I think you need IntervalMatch functionality. Look here: IntervalMatch

HTH

Best,

Sunny

Re: Date generating problem

jagan — Wed, 19 Aug 2015 14:52:18 GMT

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.

Re: Date generating problem

Wed, 19 Aug 2015 15:13:19 GMT

HI sunny/Jagan

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

Re: Date generating problem

sunny_talwar — Wed, 19 Aug 2015 15:18:33 GMT

Awesome

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

Best,

Sunny