topic Re: need help with if then elseif endif statement syntax in QlikView

need help with if then elseif endif statement syntax

Qlik_Enthu — Sun, 27 Aug 2017 11:50:45 GMT

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

Re: need help with if then elseif endif statement syntax

vinieme12 — Sun, 27 Aug 2017 12:10:09 GMT

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

Re: need help with if then elseif endif statement syntax

Kushal_Chawda — Sun, 27 Aug 2017 12:29:08 GMT

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

Re: need help with if then elseif endif statement syntax

Qlik_Enthu — Sun, 27 Aug 2017 13:56:12 GMT

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

thanks again

Re: need help with if then elseif endif statement syntax

Qlik_Enthu — Mon, 04 Sep 2017 15:54:17 GMT

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

Re: need help with if then elseif endif statement syntax

Kushal_Chawda — Mon, 04 Sep 2017 16:39:20 GMT

would you be able to share the sample?

Re: need help with if then elseif endif statement syntax

Qlik_Enthu — Tue, 05 Sep 2017 05:15:57 GMT

hi, attached is my application..

Regards,

Sai