topic Re: Pie Chart %? in QlikView

Pie Chart %?

cbaqir — Wed, 06 Dec 2017 21:56:13 GMT

As you can see from the highlight below, there is 1 out of 51 tickets in PPAG but it's showing as 65%. My expression is

=((Sum(
Aggr(Count({$<DEFECT_ID = e({<CUR_STATUS ={'Closed' , 'Denied' , 'Dismissed' , 'Closed - Maintenance'} >})
*e({<COM_CAT ={'ERC - Assigned'} >})
* e({<COM_CAT ={'ERC - Routing'} >})
* e({<COM_CAT ={'ERC - Routing - Agenda'} >})
* p({<COM_CAT ={'Decision Body(s) - Design'}>}) >}
distinct DEFECT_ID), PRIMARY_DECISION_BODY,DEFECT_ID) ))
/
(Sum(
Aggr(Count({$<DEFECT_ID = e({<CUR_STATUS ={'Closed' , 'Denied' , 'Dismissed' , 'Closed - Maintenance'} >})
*e({<COM_CAT ={'ERC - Assigned'} >})
* e({<COM_CAT ={'ERC - Routing'} >})
* e({<COM_CAT ={'ERC - Routing - Agenda'} >})
* p({<COM_CAT ={'Decision Body(s) - Design'}>}) >}
total distinct DEFECT_ID), PRIMARY_DECISION_BODY,DEFECT_ID) )) * 100)

Re: Pie Chart %?

vishsaggi — Wed, 06 Dec 2017 22:27:19 GMT

Are you looking for this?

Try this?

=Num((Sum(

Aggr(Count({$<DEFECT_ID = e({<CUR_STATUS ={'Closed' , 'Denied' , 'Dismissed' , 'Closed - Maintenance'} >})

*e({<COM_CAT ={'ERC - Assigned'} >})

* e({<COM_CAT ={'ERC - Routing'} >})

* e({<COM_CAT ={'ERC - Routing - Agenda'} >})

* p({<COM_CAT ={'Decision Body(s) - Design'}>}) >}

distinct DEFECT_ID), PRIMARY_DECISION_BODY) ))

(Sum(

Aggr(Count({$<DEFECT_ID = e({<CUR_STATUS ={'Closed' , 'Denied' , 'Dismissed' , 'Closed - Maintenance'} >})

*e({<COM_CAT ={'ERC - Assigned'} >})

* e({<COM_CAT ={'ERC - Routing'} >})

* e({<COM_CAT ={'ERC - Routing - Agenda'} >})

* p({<COM_CAT ={'Decision Body(s) - Design'}>}) >}

total distinct DEFECT_ID), PRIMARY_DECISION_BODY) )) ,'#,##0.00%' )

Re: Pie Chart %?

cbaqir — Wed, 06 Dec 2017 22:55:49 GMT

was it just missing the num format?

Re: Pie Chart %?

vishsaggi — Wed, 06 Dec 2017 23:24:10 GMT

No your aggr function in the expression has field DEFECT ID as one of the aggr field, but in your chart you are using only has PRIMARY_DECISION_BODY as your dimension so removed that DEFECT_ID.