topic Pie Chart Expression Trouble in QlikView

Pie Chart Expression Trouble

CN — Wed, 25 Nov 2020 16:16:04 GMT

I have two fields in the same table that I would like to compare with a pie chart. I don't know what I'm doing wrong, but it's not working. I want to display the sum of rejects by reject type. The two fields are called, (StkScrapCnt) and (ProdScrapCnt).

In the Dimensions for the Pie Chart I wrote an expression for each dimension, which was =Sum (StkScrapCnt) and =Sum (ProdScrapCnt).

What am I doing wrong?

Re: Pie Chart Expression Trouble

rubenmarin — Thu, 28 Mar 2019 21:58:57 GMT

I think you need set Reject type as dimension and use two expressions: Sum (StkScrapCnt) and Sum (ProdScrapCnt)

Or use two pie charts, one for each expression. Radar chart, bar chart and line chart can also help to compare two metrics

Re: Pie Chart Expression Trouble

jonathandienst — Fri, 29 Mar 2019 05:13:29 GMT

A pie chart is not a great way to compare values. Unless the ratio itself is the relevant takeaway, I would use a pair of linear gauges or a bar chart.