topic If condition is not working in QlikView

If condition is not working

NavinReddy — Mon, 26 Jan 2026 16:26:21 GMT

Hi All,

below if condition is not working for me, kindly please suggest.

if(Match(trim([Product Code]),'3')and [Product Code]='3', 'text', 'text1')

Thanks,

vchuprina — Wed, 27 Apr 2022 08:17:41 GMT

Hi,

Trim function removes spaces near value, so I assume that you have spaces, for instance

' 3' or ' 3 '

In this case, the first part of your expression returns true because trim removes spaces and you get '3'

Match(trim([Product Code]),'3')

But the second part returns false because the Product Code value still contains spaces

[Product Code]='3',

You can just replace your condition by following:

if(trim([Product Code]) = '3', 'text', 'text1')

Regards,

Vitalii

NavinReddy — Wed, 27 Apr 2022 08:55:57 GMT

Hi Vitalli,

Thanks for your quick response, i tried with option but still not working. any other set analysis/other options.

if([Product Code]='3' or Match(trim([Product Code]),'3'),'text','text1')

Regards,

vchuprina — Wed, 27 Apr 2022 09:40:48 GMT

Could you please share your result? I don't understand where you try to use this condition in the UI or in the script part.

Regards,

Vitalii