topic Re: If Statement variable not working with equals sign in Edit Script in QlikView

If Statement variable not working with equals sign in Edit Script

Fri, 13 Jun 2014 14:42:08 GMT

Hi, beginner here,

let computer = ComputerName();

If $(computer) = $(computer) then

Set vDrive = a;

else

Set vDrive = b;

end if

I am using this " If $(computer) = $(computer) ", because I know it will equal, expecting the IF statement to go to Set vDrive = a;

but the code keeps going to Set vDrive = b; not sure what is going on, any help is extremely appreciated.

Re: If Statement variable not working with equals sign in Edit Script

Jason_Michaelides — Fri, 13 Jun 2014 14:43:50 GMT

Try If $(computer) = '$(computer)' - note the apostrophes added.

Re: If Statement variable not working with equals sign in Edit Script

jonathandienst — Fri, 13 Jun 2014 14:46:01 GMT

Hi

If you use a $ expansion, you will need to put this in quotes. But in this case, you don't need a $ expansion, for example:

If vComputer = vComputer2 Then

....

End If

HTH

Jonathan

Re: If Statement variable not working with equals sign in Edit Script

MayilVahanan — Fri, 13 Jun 2014 14:46:18 GMT

Hi

Try like this

let computer = ComputerName();

If '$(computer)' = '$(computer)' then

Set vDrive = a;

else

Set vDrive = b;

end if