Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cannot compare variable with string in IF statement

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 !!!

1 Solution

Accepted Solutions
Not applicable
Author

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

IF MoiCourant='Janvier'  then

Thank you for your answers

View solution in original post

4 Replies
anbu1984
Master III
Master III

Make sure there are no spaces after Janvier

srchilukoori
Specialist
Specialist

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
Champion II
Champion II

use variable in single quotes


If '$(MoiCourant)'='Janvier'


hope this helps

Sunil Chauhan
Not applicable
Author

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

IF MoiCourant='Janvier'  then

Thank you for your answers