topic Re: Cannot compare variable with string in IF statement in QlikView

Cannot compare variable with string in IF statement

Sun, 11 May 2014 14:29:10 GMT

Hi ,

Here is my script , but it's not working , i don't know if i'm missing something , please help :

If $(MoiCourant)='Janvier' then

EXECUTE cmd.exe /C rmdir /Q /S $(vCheminHomeQVD)QVDs_Avril$(vAnneePrecedante);

ELSE

EXECUTE cmd.exe /C rmdir /Q /S $(vCheminHomeQVD)QVDs_Mars$(vAnneePrecedante);

END IF

it always do the Else , when i do a TRACE $(MoiCourant) it shows Janvier !!!

anbu1984 — Sun, 11 May 2014 14:39:10 GMT

Make sure there are no spaces after Janvier

srchilukoori — Sun, 11 May 2014 14:47:38 GMT

Enclose the variable in quotes.

If '$(MoiCourant)'='Janvier' then

EXECUTE cmd.exe /C rmdir /Q /S $(vCheminHomeQVD)QVDs_Avril$(vAnneePrecedante);

ELSE

EXECUTE cmd.exe /C rmdir /Q /S $(vCheminHomeQVD)QVDs_Mars$(vAnneePrecedante);

END IF

SunilChauhan — Sun, 11 May 2014 14:47:58 GMT

use variable in single quotes

If '$(MoiCourant)'='Janvier'

hope this helps

Mon, 12 May 2014 10:38:19 GMT

I correct it , i just used the variable without $() , like this :

IF MoiCourant='Janvier' then

Thank you for your answers