topic Re: Help required in QV graph in QlikView

Help required in QV graph

Anonymous — Tue, 06 Oct 2015 04:52:17 GMT

Hi,

With help of community i have near about completed the application.

Two things are still pending-

1. Requesting you to check whi P1 is not coming in the KPI graph.

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

Please help.

Regards

Anutosh

I have added the application

Re: Help required in QV graph

Tue, 06 Oct 2015 05:36:45 GMT

Hi Suman,

I have attached the file, there is no entry for P1 as its Status value is not 'CLOSED'.

Hope it helps you.

Re: Help required in QV graph

tresB — Tue, 06 Oct 2015 05:51:42 GMT

Suman Dhar wrote:

1. Requesting you to check whi P1 is not coming in the KPI graph.

Because that has zero value and zero value is supressed. You can change the setting in the presentation tab to make it appear.

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

Include the 'Closed' condition in the first part of your expression as well, like:

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

Re: Help required in QV graph

sujeetsingh — Tue, 06 Oct 2015 05:55:21 GMT

1. Requesting you to check whi P1 is not coming in the KPI graph.

Answer: This is due to supress zero values

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

Re: Help required in QV graph

Anonymous — Tue, 06 Oct 2015 07:12:54 GMT

Thanks for your reply-

May be i am not expressed properly. Result of your application is not showing properly.

I want-

Severity KPI Time(HRS) AVG resolution time(HRS)

-----------------------------------------------------------------

P1 3 2.25 (Calculation- Total time taken to resolve p1 ticket/no of p1 ticket). We need to consider only closed ticket

P2 4 3.29

P3 8 5.65

P4 NO SLA 150

P5 NO SLA 129

Re: Help required in QV graph

Anonymous — Tue, 06 Oct 2015 11:50:22 GMT

If I update the sheet P1 with closed status still it is not coming.If I uncheck the zero values then it breaks into multiple rows.

Re: Help required in QV graph

Anonymous — Tue, 06 Oct 2015 13:38:36 GMT

This code is not working

Re: Help required in QV graph

Anonymous — Tue, 06 Oct 2015 15:12:35 GMT

Please help

Re: Help required in QV graph

Anonymous — Tue, 06 Oct 2015 18:06:16 GMT

I have checked avg is not coming properly in my graph. I have mentioed the calculation.

As per my example-

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

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

Re: Help required in QV graph

Anonymous — Wed, 07 Oct 2015 03:29:33 GMT

please give me soime suggestion

Re: Help required in QV graph

Anonymous — Wed, 07 Oct 2015 09:43:00 GMT

Can anyone help me on that?