topic Re: How can I generate days between differents type ? in QlikView

How can I generate days between differents type ?

suzel404 — Fri, 13 May 2016 20:34:15 GMT

Hi all,

How can I generate all days between differents TYPE_ID ?

STORE_ID STATE_ID TYPE_ID DATE_START DATE_END

I want to generate all days between differen TYPE_ID until TYPE_ID <> 9

How can I achieve it ?

Many thanks for your help.

Regards

sunny_talwar — Fri, 13 May 2016 20:37:36 GMT

Not sure I understand what the required output is, can you please elaborate

Fri, 13 May 2016 20:48:11 GMT

As per my understanding you need to generate the all date between DATE_START and DATE_END.

Please find the below:

Source:

Load

STORE_ID,

STATE_ID,

TYPE_ID,

DATE_START,

DATE_END

From source_Table;

Final:

LOAD

STORE_ID,

STATE_ID,

TYPE_ID,

DATE_START + IterNo() - 1 AS Date_ID

Resident Source

Where Not Isnull(DATE_END)

While iterNo() <= (DATE_END - DATE_START)+1

;

suzel404 — Fri, 13 May 2016 21:40:06 GMT

Hi Sunny,

I want to generate a master calendar with all days between TYPE_ID

Generate all day from 01/01/2015 to 12/01/2015 until TYPE_ID <> 9.

When I click on ST001 and state = 1 and type_id = 10 I can see all days from 01/01/2015 to 08/01/2015 and for each type_id.

ST001	1	10	01/01/2015	08/01/2015
ST001	1	45	08/01/2015	12/01/2015

suzel404 — Sat, 14 May 2016 11:23:02 GMT

Many thanks for help.

Thanks dathu.qv