topic Re: Variable not evaluating in QlikView

Variable not evaluating

Anonymous — Thu, 24 Aug 2017 13:10:08 GMT

Hi everybody

Set vbg7='G'

Set vBG6='R'

If(vbg7 = 'G' and vBG6 <> 'G', vBG6, vbg7)

with above formula I'm still getting 'G' instead of 'R', what mistake I'm making?

Thanking you

Clever_Anjos — Thu, 24 Aug 2017 13:59:27 GMT

Getting R, here

sunny_talwar — Thu, 24 Aug 2017 14:02:57 GMT

May be share your app

vvvvvvizard — Thu, 24 Aug 2017 14:09:56 GMT

If(vbg7 = 'G' and vBG6 <> 'G', 1,2)

Do you get one or two

vvvvvvizard — Thu, 24 Aug 2017 14:13:59 GMT

Copy this to script

Set vbg7='G';

Set vBG6='R';

now in textbox add

=If(vbg7 = 'G' and vBG6 <> 'G', vBG6, vbg7)

Anonymous — Thu, 24 Aug 2017 14:33:57 GMT

Hi Guys

I appreciate your help, btw in my case vbg7 needed to evaluate ($(vbg7)) first.

Now works

Thanking you all of you for your valuable time