topic Re: Recording dates that values change in QlikView

Recording dates that values change

Mon, 15 Apr 2013 15:50:23 GMT

Looking at the data set below

Date,Stock Code,Stock Level

01/01/2010,STK1,11

02/01/2010,STK1,10

03/01/2010,STK1,8

04/01/2010,STK1,1

05/01/2010,STK1,0

06/01/2010,STK1,0

07/01/2010,STK1,0

08/01/2010,STK1,20

09/01/2010,STK1,1

10/01/2010,STK1,1

11/01/2010,STK1,1

01/01/2010,STK2,20

02/01/2010,STK2,20

03/01/2010,STK2,18

04/01/2010,STK2,18

05/01/2010,STK2,0

06/01/2010,STK2,0

07/01/2010,STK2,0

08/01/2010,STK2,0

09/01/2010,STK2,0

10/01/2010,STK2,0

11/01/2010,STK2,20

12/01/2010,STK2,0

13/01/2010,STK2,0

14/01/2010,STK2,0

15/01/2010,STK2,20

Is it possible to create a report similar to:

Stock Item,Date When Out of Stock, Date When Back In Stock, Number of Days

STK1,05/01/2010,08/01/2010,3

STK2,05/01/2010,11/01/2010,5

STK3,12/01/2010,15/01/2010,3

If so can you please point me at an articale that explains how to do this.

Thanks

Andy

Re: Recording dates that values change

Mon, 15 Apr 2013 17:20:05 GMT

Hi ,

You refer this http://community.qlik.com/message/335288#335288 .

If you need some other solution please reply me the Correct Sample Data Output .

//Yusuf

Re: Recording dates that values change

Gysbert_Wassenaar — Mon, 15 Apr 2013 17:39:16 GMT

See attached example

Re: Recording dates that values change

Tue, 16 Apr 2013 13:25:50 GMT

Thank you both for your help.

Re: Recording dates that values change

Tue, 16 Apr 2013 14:24:45 GMT

Hi Gysbert, is there anyway I can show a record if the item is still out of stock.