Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
satishkamath
Contributor II

Variable not evaluating

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

5 Replies
Employee
Employee

Re: Variable not evaluating

Getting R, here

Capturar.PNG

Re: Variable not evaluating

May be share your app

vvvvvvizard
Contributor III

Re: Variable not evaluating

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

Do you get one or two

vvvvvvizard
Contributor III

Re: Variable not evaluating

Copy this to script

Set vbg7='G';

Set vBG6='R';

now in textbox add

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

satishkamath
Contributor II

Re: Variable not evaluating

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

Community Browser