topic Re: Cumulative Incidents resolved within SLA in QlikView

Cumulative Incidents resolved within SLA

0li5a3a — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a new challenge regarding how to create a cumulative incidents chart.

Is a way to do this in set analysis? I have attached the excel files where you can see in the Cumulative Within SLA Tab how I do the calculation.

For ex:

Oct-17 I do sum(Within SLA - Yes) / total which is 46/73 = 63.01%

Nov-17 I do sum(OCT-17 + Nov -17) / SUM(OCT-17 +NOV-17) which is (46+40)/(73+76) = 52.63%

Thanks

timpoismans — Tue, 23 Oct 2018 09:07:05 GMT

Your Cumulative Within SLA column isn't cumulative, it's just calculated on row level.

That said, take a look at the following:

It's made in Qlik Sense, but the measure should work for QV as well.

Measure:

RangeSum(Above(Sum([Within SLA - Yes]),0,RowNo())) / RangeSum(Above(Sum(Total),0,RowNo()))

yoganantha321 — Tue, 23 Oct 2018 12:30:10 GMT

what is your expected output?

As you want like above said by Tim