topic Re: Days in QlikView

Days

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Please find the attachment of the QVW file and the related data .

I need to show AVG of Resolved date and for Closed date for 2018 and 2017 for the Key .

For resolved date = resolved - Created is the formula for it ..

For Closed = Closed-Created .

How do i get this ?..

I need to show current and previous year for Resolved date .

As shown in the screenshot below

Thanks in advance .

Anonymous — Mon, 03 Sep 2018 10:57:30 GMT

define a Pivot table with

calculated Dimension =if (Resolvedyear>=2017, Resolvedyear)

and two expressions

-=avg(date(Resolved)-date(Created))

=avg(date(Closed)-date(Created))

and bring Dimension and expressions in this Format (drag and drop)

jyothish8807 — Mon, 03 Sep 2018 10:58:44 GMT

Hi John,

Check this sample.

Br,

smilingjohn — Mon, 03 Sep 2018 12:32:20 GMT

Hi Jyothish,

Why are you considering the status ? and what is D here ?

Thanks

jyothish8807 — Wed, 05 Sep 2018 04:52:58 GMT

Hi John,

I just added Status field as per my understanding, you ca remove them or change the status as per your requirment.

'd' stands for days, i am taking the interval between both the dates in 'days' and then taking the avg of it.

Br,