error in expression ')' expected qlikview

[suryaa30]

The below expression in chart gives error. The syntax in expression editor does not throw any error.

Can someone suggest what needs to be tweaked in below expression

= IF($(eGrowthAvgPremium_CYvsPY)<1,'qmem://ImageName/RedArrow',IF(1<$(eGrowthAvgPremium_CYvsPY)<=$(eGrowthGoalSales_CYvsPY),'qmem://<bundled>/BuiltIn/minus.png',IF($(eGrowthAvgPremium_CYvsPY)>$(eGrowthGoalSales_CYvsPY),'qmem://ImageName/GreenArrow')))

Expressions when evaluated by parts work fine.

eGoalSalesCY=Sum({< GoalSales_Year = {'$(=Max(GoalSales_Year))'} >} Goals)

eGrowthGoalSales_CYvsPY=(($(eGoalSalesCY) / $(eGoalSalesPY))-1)

eGrowthAvgPremium_CYvsPY=($(eAvgPremiumCY)/$(eAvgPremiumPY)-1)

[vishsaggi]

= IF($(eGrowthAvgPremium_CYvsPY)<1,'qmem://ImageName/RedArrow',

  IF(1 < $(eGrowthAvgPremium_CYvsPY)<=$(eGrowthGoalSales_CYvsPY),'qmem://<bundled>/BuiltIn/minus.png',IF($(eGrowthAvgPremium_CYvsPY)>$(eGrowthGoalSales_CYvsPY),'qmem://ImageName/GreenArrow')))

Can you rectify the one highlighted in the red.

[sunny_talwar · Accepted solution]

May be this

If($(eGrowthAvgPremium_CYvsPY) < 1,'qmem://ImageName/RedArrow',

If(1 < $(eGrowthAvgPremium_CYvsPY) and $(eGrowthAvgPremium_CYvsPY) <= $(eGrowthGoalSales_CYvsPY), 'qmem://<bundled>/BuiltIn/minus.png',

If($(eGrowthAvgPremium_CYvsPY) > $(eGrowthGoalSales_CYvsPY), 'qmem://ImageName/GreenArrow')))

[mostwanted123]

Hi Surya,

Try this,

If($(eGrowthAvgPremium_CYvsPY)<1,'qmem://ImageName/RedArrow',if($(eGrowthAvgPremium_CYvsPY)<=$(eGrowthGoalSales_CYvsPY),'qmem://<bundled>/BuiltIn/minus.png',if($(eGrowthAvgPremium_CYvsPY)>$(eGrowthGoalSales_CYvsPY),'qmem://ImageName/GreenArrow')))

Regards,

Pratik

[suryaa30]

Hi Vishwarath,

I am sorry I am not able to interpret what has to be changed??

[vishsaggi]

As suggested by Sunny in his reply, do like 1 < yourvariablename AND yourvariablename <= variablename.

[suryaa30]

Hi All I understand <1 condition is causing the error but what is wrong in the syntax. can someone please elaborate?

[hari8088]

Not sure but look it once on marked one with blue

IF($(eGrowthAvgPremium_CYvsPY)<1,'qmem://ImageName/RedArrow',IF(1<$(eGrowthAvgPremium_CYvsPY)<=$(eGrowthGoalSales_CYvsPY),'qmem://<bundled>/BuiltIn/minus.png',IF($(eGrowthAvgPremium_CYvsPY)>$(eGrowthGoalSales_CYvsPY),'qmem://ImageName/GreenArrow')))

[sunny_talwar]

If condition in qlik cannot be like this

A < x < B... instead you need like this

A < x and x < B

[suryaa30]

Thanks Much Sunny