Claculating net working days

[#1]

Hi,

I have columns of data that I am importing

Claim no

Status

Last change date

the last change date is not time stamped.

how would I go ahead to calculate the net working days between specific Statuses.

what graph would be the best to use?

It is very easy to do in excel, but I would like to automate it in qlikview.

[gerry_hdm]

Hello Gerald

hi could you also provide kernel a timestamp instead of the date. Then you had the correct sequence

greatings from Germany

Gerold

[#3]

Hi Gerry, unfortunately, there is only a date stamp.

[jpenuliar]

Is that 75 Statuses on Write-off tab?

yeah that seems a lot, and probably no way to tell which performances your user would want to look at.

You can probably do Ad-hoc style Straight Table, with 2 listboxes(Always one selected Value) to select Status 1 and Status 2, which triggers to show in your Chart to 2 expressions showing the corresponding Dates and the third expression to Networkdays().

Obviously, this will only show 1 active performance metric, if your Customer wants to see more, that's another problem.

[#5]

Hi Gerald,

can you not just limit the initial load then to just those statuses? And then concatenate the remainder at the end if you still need to see them

Joe

[robert_mika]

This is not fully workable solution but from what I have read you need to choose status from two fields to get the difference.

In attached you have draft of what I think this could look like:

Two sites, two states.

Left with "from" the right with "To" and in the middle the result.

You need to pick up the Claim number and status for both of the parts to get the result in "Difference in days box".

I can not make to work one ClaimNo field to affect both states and as well you need to know which status is previous to another.
Maybe someone else could pick this up to develop full workable solution