Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
CN
Contributor II
Contributor II

Pie Chart Expression Trouble

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?

 

2 Replies
rubenmarin

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
jonathandienst
Partner - Champion III
Partner - Champion III

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. 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein