topic Table with dates in QlikView

Table with dates

reijk317 — Fri, 17 Nov 2017 09:05:10 GMT

I need some help.

I have a table with a id, startdate and enddate.

I like to make a table with the id and the dates like my example.

How do ik do this.

My next question is, how can i display this in a calendar like this?

Anil_Babu_Samineni — Fri, 17 Nov 2017 09:40:25 GMT

1) Like this

Load ID, Startdate + Iterno()-1 as Date

While Startdate + Iterno()-1 <= Enddate;

Load ID, Startdate, Enddate From Table;

2) You need to develop this using Pivot table.

woshua5550 — Fri, 17 Nov 2017 11:29:41 GMT

plz check the attachment,hope it can help you