topic Capturing Status every Prior 2 weeks in QlikView

Capturing Status every Prior 2 weeks

nadkalyan — Mon, 11 Jul 2011 17:27:39 GMT

Hi,

We have a requirement to show the status changed Items based on Prior 2 weeks as of current Date.

Item ID	Date	Status
A001	6/28/11	Open
A002	6/28/11	Open
A001	07/11/11	Closed
A002	07/11/11	Open

As in above Table, I would like to Capture the Status of each Item ID every 2 weeks as of current Date(07/11/11). In this example my Count of ItemID with status changes in last 2 weeks is 1 (A001).

How can we capture the changes based on time period in Qlikview and also compare data row by row?

Thanks

Kalyan

Capturing Status every Prior 2 weeks

rwunderlich — Mon, 11 Jul 2011 20:53:32 GMT

Tell us a little bit about your source data. Do you have status change dates and you want to derive what the status was on a given date? Or do you want to save current status snapshots going forward?

-Rob

Capturing Status every Prior 2 weeks

nadkalyan — Tue, 12 Jul 2011 11:59:36 GMT

Hi Rob,

We do have all the data that i showed in above table in the Database. I just wanted to know if there is a way to capture the Status on timely basis in Qlikview. But my actual issue is to be able to compare Row by Row Status. As in above example - If i need to get a count of Items (ItemID) that changed status from Open to Closed in last 2 weeks, by eye balling data of 4 rows I can say my Count is 1 ; But how can we implement a logic in Qlikview that compares Row by Row for all ItemID's and gives me count of all Items (ItemID) where status changed from Open to Closed in specified Time Frame ( in my case last 2 weeks).

Please let me know if you need me to provide any more information.

Thanks

Kalyan

Re: Capturing Status every Prior 2 weeks

Thu, 14 Jul 2011 05:10:55 GMT

Dear Kalyan,

U may try this attached sample apllication.

This will help u...

Best luck.........