From Date-To Date from QVD

Mon, 04 May 2015 05:56:50 GMT

Hello Team,

I have a QVD which has product details. The fields are product id, product name, price, update date.

Now a product price and product name can change for a product id. I want to maintain versions and later on using interval match I would like to see what was the price/name during that interval. The update data monitors the day of change.

Can someone explain how to put a from date and to date field to capture the change using a QVD.

Please have a look at the attached excel for the data. The product id 123 and 234 has both price change and name change.

Thanks,

Re: From Date-To Date from QVD

Gysbert_Wassenaar — Mon, 04 May 2015 08:34:35 GMT

So if I understand you correctly you have only one date field named update date and you want to create a from date and to date fields from that. If that's right then read this blog post: Creating a Date Interval from a Single Date‌. You might want to read this document too: IntervalMatch and Slowly Changing Dimensions

topic Re: From Date-To Date from QVD in QlikView

From Date-To Date from QVD

Re: From Date-To Date from QVD