Not Equal To with Variable

[khigaurav999]

Hi Friends & Community Members,

I am new to QV. I need to change the caption of text object/button object depending upon value of a variable. Basically, I want caption to be Show CR Details when var_Active_CR_Details -='Y' otherwise Hide CR Details.I

I tried following expression: =if(var_Active_CR_Details -='Y','Show CR Details','Hide CR Details') but this is giving syntaxt error.

Also tried followings:

=if(var_Active_CR_Details ='*' - 'Y','Show CR Details','Hide CR Details')
and =if(var_Active_CR_Details ={'*'}-{'Y'},'Show CR Details','Hide CR Details')

but it also doesn't work and help me achive what i want.

Please let me know how can i achieve it. Thanks for your help with this in advance.

Gaurav

[avinashelite · Accepted solution]

try this

=if(var_Active_CR_Details <>'Y','Show CR Details','Hide CR Details')

in if condition not equal to us <>

in set analysis -=

Hope you got the answer

[sunny_talwar]

You can also use not Match() function here

=If(not Match(var_Active_CR_Details, 'Y'), 'Show CR Details', 'Hide CR Details')

or you can turn around the if statement to check if it is Y

=If(var_Active_CR_Details = 'Y', 'Hide CR Details', 'Show CR Details')

[khigaurav999]

thanks this is working!