topic Re: Days between in QlikView

Days between

Fri, 06 Nov 2015 00:17:22 GMT

Hi Friends,

I want to show the Days between 2 status (from below sample data).

Ex: for Status = 2, the days should be difference between min(Date) for Status = 2 and min(Date) for status = 3 (Which is next status to 2)

I thought the below formula would work but it is giving days between same status (say for status =2, I am getting days as 7)

NetWorkDays(min(Date), max(Date))

Contract	Date	Status
2	2/24/2015	2
2	2/18/2015	2
2	2/23/2015	2
2	2/24/2015	2
2	3/6/2015	3

Any help will be appreciated.

Re: Days between

miguelbraga — Fri, 06 Nov 2015 11:45:09 GMT

Hi Anjan,

Why don't you use set analysis like this:

=min({$<Status = {'2'}> Date} ) - min({$<Status = {'3'}>} Date)

Regards,

Re: Days between

Mark_Little — Fri, 06 Nov 2015 11:48:24 GMT

Hi,

Give the below a try,

=NetWorkDays(Max({<Status={2}>}Date) ,Min({<Status={3}>}Date))

Mark

Re: Days between

Sun, 08 Nov 2015 00:56:13 GMT

Hi Miguel and Mark,

I just gave a subset of data. Actually my data has 1 to 10 status and my expression has to get the Days between status in the above specified way.

Re: Days between

sunny_talwar — Sun, 08 Nov 2015 10:07:20 GMT

So you want to get difference between starting days for each of the statuses??? Do you only have information about a single contract? or do you have multiple contracts and each have 1 to 10 statuses?

Re: Days between

maxgro — Sun, 08 Nov 2015 10:25:58 GMT

PFA