How To calculate days difference between one date field

[#1]

My Input file is like this :

Id   Status   Date

101    1     1-8-2012

101    2     10-8-2012

101    3      15 -8-2012

101    4       25-8-2012

102    1       3-8-2012

102    2       16-8-2012

My out put is like this :

Id    Days(days difference between status 2 - status 1)   Days(days difference between status 3 - status 2)  

101       9 days                                                             5 days

102       13 days                                                             ---

It is possible to qlikview

[daveamz · Accepted solution]

Hi,

It is possible, but depends on the real data set.

If you have only 1 date per status per id and only few states per id you can use set analysis (see the example attached).

Regards,

David

[#3]

Thanx Dave

Its Working