Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Register by January 31 for $300 off your Qlik Connect pass: Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
brindlogcool
Creator III
Creator III

If condition

Hi,

What is the difference between below expressions 1 and 2.

1. if(A or B,1,0)

2. if(A=1 or B=1,1,0)

How to interpret the 2 expressions

1 Solution

Accepted Solutions
pover
Partner - Master
Partner - Master

In QV,

0 is False and any other number is True

so the first expression will return 1 if as long as A and B aren't 0 and the second expression will return 1 as long as A or B is 1.

Karl

View solution in original post

2 Replies
pover
Partner - Master
Partner - Master

In QV,

0 is False and any other number is True

so the first expression will return 1 if as long as A and B aren't 0 and the second expression will return 1 as long as A or B is 1.

Karl

brindlogcool
Creator III
Creator III
Author

Hi Karl,

Thanks for your response. It is really helpful.