topic Re: Not Equal To with Variable in QlikView

Not Equal To with Variable

khigaurav999 — Wed, 22 Mar 2017 06:55:00 GMT

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

Re: Not Equal To with Variable

avinashelite — Wed, 22 Mar 2017 06:57:01 GMT

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

Re: Not Equal To with Variable

sunny_talwar — Wed, 22 Mar 2017 07:26:04 GMT

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')

Re: Not Equal To with Variable

khigaurav999 — Wed, 22 Mar 2017 07:28:04 GMT

thanks this is working!