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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
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.