Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
qvhelpplease
New Contributor III

help on pie chart

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

kush141087rwunderlichswuehlstalwar1maxgrocleveranjosmaxgrojaganmaxgro

6 Replies
Partner
Partner

Re: help on pie chart

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

marinasbc
New Contributor III

Re: help on pie chart

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'))

qvhelpplease
New Contributor III

Re: help on pie chart

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

please you please apply the same on the qvw i attached

marinasbc
New Contributor III

Re: help on pie chart

Try the app attached

qvhelpplease
New Contributor III

Re: help on pie chart

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

qvhelpplease
New Contributor III

Re: help on pie chart

ticket count is not correct