Recording dates that values change

[#1]

Hi

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

[#2]

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

[Gysbert_Wassenaar]

See attached example

[#4]

Thank you both for your help.

[#5]

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