Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

gumstero
Not applicable

Generate dates between status changes.

Hi,

I want to generate one row for each ID, Date and PaymentType.

I have records for ID's with no start date from one table and another table that has the LogDate (change date) for each PaymentType.

I can set a start date for the first table from lets say 2017-01-01 and then generate one row per day up until the Payment Type changes.

When the Payment Type changes I want to generate a date until Payment Type changes again and so on.

The next problem is that the SubscriberID can go back to the table without dates and then I need to set the last change date as start date in that table.

I know this is quite common problem but I've tried several solutions and checked others as well like:

Generating Missing Data In QlikView

I've attached an example file with data.

Any help is welcome!