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: 
fandybow
Contributor
Contributor

If And Question

Hello,

I need help.

I have some criteria which consists of the following:

NameSales 2018Sales 2019Growth
A155,471,000218,313,00062,842,000
B0160,174,1000
C201,561,30000
D335,127,700246,324,000-88,803,700
E87,421,30000
F259,059,400275,161,00016,101,600
G206,104,300185,311,000-20,793,300
H195,334,40000
I203,839,100196,328,000-7,511,100
J0389,833,0000
K491,257,100603,016,100111,759,000
L440,301,20000
M152,800,200178,219,00025,418,800
N149,862,50000

 

the idea is that : =IF(AND(C2>0,B2>0),C2-B2,0)

Any Ideas on how I can tackle this would be highly appreciated.

Thank you in advance for your time.

Fandy

1 Solution

Accepted Solutions
SergeyMak
Partner Ambassador
Partner Ambassador

Try

SUM({<C2={">0"},B2={">0"}> } C2-B2)

Regards,
Sergey

View solution in original post

2 Replies
zhadrakas
Specialist II
Specialist II

try it like this:

=IF(C2>0 AND B2>0,C2-B2,0)

regards

SergeyMak
Partner Ambassador
Partner Ambassador

Try

SUM({<C2={">0"},B2={">0"}> } C2-B2)

Regards,
Sergey