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