Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Suppress zero values in pie chart

Hello,

I have a data set imported from an SQL Table like:

SubjectInvoice No.
1-3031-6061-90Total Amount
Subject 1Inv00110000100
Subject 1Inv00202000200
Subject 2Inv00300100100
Subject 2Inv004050050

I want to create a pie chart to show me each column summary share in the total amount for the columns 1-30, 31-60, 61-90. I don't have any dimension in the pie chart, I only have expressions for each share that I need:

SUM([1-30])/SUM(Amount)

SUM([31-60])/SUM(Amount)

SUM([61-90])/SUM(Amount)

The problem that I get is that the pie chart always shows zero values although it's marked suppress zero values in the presentation tab

Test Pie Chart.jpg

Does anyone have a solution for this?

Thank you...

Djordje

3 Replies
Not applicable
Author

try this

SUM([1-30])/SUM({<Amount= {">0"}>}Amount)

SUM([31-60])/SUM({<Amount= {">0"}>}Amount)

SUM([61-90])/SUM({<Amount= {">0"}>}Amount)

Not applicable
Author

It doesn't work, I mean, I get the same result with this.

Not applicable
Author

Djordje,


We can fix this by using expression conditions. check the attached qvw.

hope this solves your pie chart issue.


thanks

Brad.