This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration on QlikView Integration.
below if condition is not working for me, kindly please suggest.
if(Match(trim([Product Code]),'3')and [Product Code]='3', 'text', 'text1')
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'
But the second part returns false because the Product Code value still contains spaces
You can just replace your condition by following:
if(trim([Product Code]) = '3', 'text', 'text1')
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')
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.