topic Re: help on pie chart in QlikView

help on pie chart

Anonymous — Mon, 20 Jun 2016 12:47:34 GMT

i have created a pie chart to show the percentage of tickets that met sla for response and resolve time . the problem is when i select single ticket it is showing me 50 % met and 50 % not met,where as the ticket is not correct ,.when nothing is selected it has to show the number of tickets that met and not met sla ,but when i select a single ticket it has to show only one value weather it met or not met .

i am attaching a sample qvw .pls do take a look

kush141087‌rwunderlich‌swuehl‌stalwar1‌maxgro cleveranjos maxgro jagan maxgro

Re: help on pie chart

Anonymous — Mon, 20 Jun 2016 13:06:54 GMT

the problem is that on your calculated Dimension you compare with INSECS (<= INSECS).

INSECS has several valkues. If you select only one or two data of INSECS it Shows correct.

I donot have a solution for your Problem (<=sum(INSECS) does not work)

maybe you try with set analysis

Re: help on pie chart

marinasbc — Mon, 20 Jun 2016 14:19:47 GMT

Rudolf Linder is correct, but you could re-write the calculated dimension to:

=if(ticket_status='Resolved' or ticket_status='Closed' and [st]=('Incidents')and Master_Category=('Access only')

,if(

if(GetFieldSelections(RES)='RESOLUTION TIME',

ResolveDIFF_IN_SEC,

ResponseDIFF_IN_SEC)

<= aggr(sum(INSECS), ticket_number),

'SLAMET',

'NOTmet'))

Re: help on pie chart

Anonymous — Mon, 20 Jun 2016 15:44:27 GMT

its taking everything as slamet ,should we change the expression too ?

please you please apply the same on the qvw i attached

Re: help on pie chart

marinasbc — Mon, 20 Jun 2016 16:14:13 GMT

Try the app attached

Re: help on pie chart

Anonymous — Mon, 20 Jun 2016 16:20:03 GMT

i am not sure of how to do it ,can you please post the script

Re: help on pie chart

Anonymous — Mon, 20 Jun 2016 17:38:56 GMT

ticket count is not correct