need help with if then elseif endif statement syntax

[Qlik_Enthu]

dear all,

below is my code in my load script editor. getting semantic error and syntax error. kindly help me identify the mistake:

IF ($('vStatus')='GREEN' AND $('vStatus1')='GREEN') THEN
Let vShowCS = 1;
ELSEIF ($('vStatus')='GREEN' AND $('vStatus1')='YELLOW') THEN
Let vShowCS = 2;
ELSEIF ($('vStatus')='GREEN' AND $('vStatus1')='RED') THEN
Let vShowCS = 3;
ELSEIF ($('vStatus')='YELLOW' AND $('vStatus1')='GREEN') THEN
Let vShowCS = 2;
ELSEIF ($('vStatus')='YELLOW' AND $('vStatus1')='YELLOW') THEN
Let vShowCS = 2;
ELSEIF ($('vStatus')='YELLOW' AND $('vStatus1')='RED') THEN
Let vShowCS = 3;
ELSEIF ($('vStatus')='RED' AND $('vStatus1')='YELLOW') THEN
Let vShowCS = 3;
ELSE ($('vStatus')='RED' AND $('vStatus1')='RED') THEN
Let vShowCS = 3;
END IF

[vinieme12]

Try referring the variable directly

IF vStatus='GREEN' AND vStatus ='GREEN' THEN
Let vShowCS = 1;
ELSEIF vStatus ='GREEN' AND vStatus1='YELLOW' THEN
Let vShowCS = 2;

......and So on

[Kushal_Chawda · Accepted solution]

Single quotes are placed wrongly, it should be ' $(VariableName)' instead $('Variable')

IF ('$(vStatus)'='GREEN' AND '$(vStatus)'='GREEN') THEN
Let vShowCS = 1;
ELSEIF ('$(vStatus)'='GREEN' AND '$(vStatus)'='YELLOW') THEN
Let vShowCS = 2;
ELSEIF ('$(vStatus)'='GREEN' AND '$(vStatus)'='RED') THEN
Let vShowCS = 3;
ELSEIF ('$(vStatus)'='YELLOW' AND '$(vStatus)'='GREEN') THEN
Let vShowCS = 2;
ELSEIF ('$(vStatus)'='YELLOW' AND '$(vStatus)'='YELLOW') THEN
Let vShowCS = 2;
ELSEIF ('$(vStatus)'='YELLOW' AND '$(vStatus)'='RED') THEN
Let vShowCS = 3;
ELSEIF ('$(vStatus)'='RED' AND '$(vStatus)'='YELLOW') THEN
Let vShowCS = 3;
ELSE ('$(vStatus)''RED' AND '$(vStatus)'='RED') THEN
Let vShowCS = 3;
END IF

[Qlik_Enthu]

thank you both and kushal`s answer worked well..

thanks again

[Qlik_Enthu]

hi,

this is my code:

LET vStatus =FieldValue('PRG_STATUS_EU',1);
LET vStatus1 =FieldValue('PRG_STATUS_EUX',1);
IF ('$(vStatus)'='GREEN' OR '$(vStatus)'='GREEN') THEN
Let vBatchStatus = 1;
ELSEIF ('$(vStatus)'='GREEN' OR '$(vStatus1)'='YELLOW') THEN
Let vBatchStatus = 2;
ELSEIF ('$(vStatus)'='GREEN' OR '$(vStatus1)'='RED') THEN
Let vBatchStatus = 3;
ELSEIF ('$(vStatus)'='YELLOW' OR '$(vStatus1)'='GREEN') THEN
Let vBatchStatus = 2;
ELSEIF ('$(vStatus)'='YELLOW' OR '$(vStatus1)'='YELLOW') THEN
Let vBatchStatus = 2;
ELSEIF ('$(vStatus)'='YELLOW' OR '$(vStatus1)'='RED') THEN
Let vBatchStatus = 3;
ELSEIF ('$(vStatus)'='RED' OR '$(vStatus1)'='YELLOW') THEN
Let vBatchStatus = 3;
ELSEIF ('$(vStatus)'='RED' OR '$(vStatus1)'='RED') THEN
Let vBatchStatus = 3;
ELSEIF ('$(vStatus)'='RED' OR '$(vStatus1)'='GREEN') THEN
Let vBatchStatus = 3;
END IF

the code highlighted in red are not working. I have set conditional show and used vBatchStatus variable value in the objects.

I couldn't find why. can u please help?

thank you,

Sai

[Kushal_Chawda]

would you be able to share the sample?

[Qlik_Enthu]

hi, attached is my application..

Regards,

Sai