Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

cbaqirdhds
Contributor II

Pie Chart %?

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)

12-6-2017 2-39-25 PM.jpg:

Tags (2)
1 Solution

Accepted Solutions
vishsaggi
Esteemed Contributor III

Re: Pie Chart %?

Are you looking for this?

Capture.PNG

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

3 Replies
vishsaggi
Esteemed Contributor III

Re: Pie Chart %?

Are you looking for this?

Capture.PNG

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

cbaqirdhds
Contributor II

Re: Pie Chart %?

was it just missing the num format?

vishsaggi
Esteemed Contributor III

Re: Pie Chart %?

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.

Community Browser