Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
michael_wernsing
Contributor II
Contributor II

Count Sales for Project entries in Pie Chart

Hi guys,

I have a problem:

I use a diagram table where I show project numbers (calles "ID") and I count, if they have already sales or not.

For sales, I say:

if((Sum([revenue in EUR]) + sum([revenue in EUR V]))>0, '1','0')

if they don't have sales, I use this one:

=count(DISTINCT ID)-(if((Sum([revenue in EUR]) + sum([revenue in EUR V]))>0, '1','0'))

Both formulas work fine for the tables, but when I want to put this into an overview pie chart, it won't work.

 

Does anyone of you have an idea what I do wrong?

 

Thanks in advance,

 

Michael

 

 

 

 

 

Labels (1)
1 Reply
michael_wernsing
Contributor II
Contributor II
Author

Any help? I appreciate any suggestion!!