If Function not working for one field

Wed, 02 Nov 2016 13:27:02 GMT

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?

Re: If Function not working for one field

stigchel — Wed, 02 Nov 2016 14:45:44 GMT

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?

Re: If Function not working for one field

m_woolf — Wed, 02 Nov 2016 14:49:55 GMT

You might try:

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

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

topic If Function not working for one field in QlikView

If Function not working for one field

Re: If Function not working for one field

Re: If Function not working for one field