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

If Function not working for one field

Hi, this is a very strange one we've encountered.  We have a basic if statement, that for one specific field, for only 3 records (out of about 100k) it fails.  So for example;

If([Product Class] = 'X', [Gender - 1],

If([Product Class] = 'Y', [Gender - 2], 'FALSE'))

For every case of Product Class = X, it returns Gender 1 field correctly.  For 99% of Y Product Class, it correctly returns Gender 2 field.  However, for 3 records with Product Class Y, it returns "FALSE."  Where things get very odd, though, is if I change the formula to be any other field besides Gender 2, it returns the correct value for those 3 records.

So it resorts to FALSE, saying the second If Statement is false, specifically ONLY for the Gender - 2 field.  Any other field, or if we hard-code it, it comes back as True and provides the correct value.

Can anyone think of a reason why this would be happening?

2 Replies
stigchel
Partner - Master
Partner - Master

No I can't, besides the obvious answer that the contents of Gender2 are 'FALSE' for these records. Are you able to provide us with those three records along with a sample document replicating the problem?

m_woolf
Master II
Master II

You might try:

If(trim([Product Class]) = 'Y',

Or

If(index(([Product Class],'Y')>0,