topic Re: Graph not showing properly in QlikView

Graph not showing properly

Anonymous — Wed, 07 Oct 2015 13:34:54 GMT

1. Two p5 entries are coming- Closed and Open but i want to show closed part.

2. P1 time taken to resolve 15:19 minutes but it is sahowing 1:01:16

Calculation-Total time taken to resolve p1 ticket(closed) /no of closed p1 ticket).

My bad- I am trying to mention about KPI resolution graph. If you change the expression of AVG resolution time then only you can get.

AVG resolution time-

=AGGR(SUM(DurationStefan)/count(TOTAL IF(UPPER(Status)='CLOSED',Severity)),P_Severity,Status)

Re: Graph npot showing properly

cjohnson — Wed, 07 Oct 2015 13:40:59 GMT

Hi Suman,

Where are you seeing P1 = 1:01:16? I see 15:19 as you originally suggested:

Thanks,

Camile

Re: Graph npot showing properly

Anonymous — Wed, 07 Oct 2015 14:44:38 GMT

My bad- I am trying to mention about KPI resolution graph. If you change the expression of AVG resolution time then only you can get.

AVG resolution time-

=AGGR(SUM(DurationStefan)/count(TOTAL IF(UPPER(Status)='CLOSED',Severity)),P_Severity,Status)

calculation should be- Total time taken to resolve p1 ticket(closed) /no of closed p1 ticket).

Re: Graph not showing properly

Anonymous — Thu, 08 Oct 2015 12:13:11 GMT

Hello please help

Re: Graph not showing properly

Anonymous — Fri, 09 Oct 2015 04:54:28 GMT

I asked for a solution but i am ot getting any reply yet. It seems qlikview is quite complicated.

Re: Graph not showing properly

cjohnson — Fri, 09 Oct 2015 14:46:35 GMT

Hi Suman,

How about just changing your expression to the following:

SUM({<Status = {'Closed'}>} DurationStefan)/COUNT({<Status = {'Closed'}>}Severity)

Does that give you the desired result?

Or if it's truly the total severity you are looking for (as the numerator) then change it to the following:

SUM({<Status = {'Closed'}>}TOTAL <P_Severity> DurationStefan)/COUNT({<Status = {'Closed'}>}Severity)

Can you give examples of actual results you are expecting?

Thanks,

Camile

Re: Graph not showing properly

Anonymous — Sat, 10 Oct 2015 17:58:06 GMT

many thanks for your help.

Apprecite it.

I have sent you attached jpeg file. In the top part i have mentioned the output which i want to display.

Re: Graph not showing properly

MarcoWedel — Sat, 10 Oct 2015 20:51:47 GMT

‌maybe helpfull:

Its not about the answer, rather it’s about the question…

QlikCommunity Tip: How to get answers to your post?

Qlik Community Tip: Posting Successful Discussion Threads

regards

Marco