topic Re: Suppress zero values in pie chart in QlikView

Suppress zero values in pie chart

Thu, 13 Aug 2015 11:32:14 GMT

Hello,

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

Subject	Invoice No.	1-30	31-60	61-90	Total Amount
Subject 1	Inv001	100	0	0	100
Subject 1	Inv002	0	200	0	200
Subject 2	Inv003	0	0	100	100
Subject 2	Inv004	0	50	0	50

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

Does anyone have a solution for this?

Thank you...

Djordje

Re: Suppress zero values in pie chart

Fri, 30 Oct 2015 13:07:01 GMT

try this

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

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

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

Re: Suppress zero values in pie chart

Wed, 04 Nov 2015 19:39:14 GMT

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

Re: Suppress zero values in pie chart

Wed, 04 Nov 2015 20:46:16 GMT

Djordje,

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

hope this solves your pie chart issue.

thanks

Brad.