topic Re: error in expression ')' expected qlikview in QlikView

error in expression ')' expected qlikview

suryaa30 — Wed, 20 Sep 2017 12:48:25 GMT

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)

Re: error in expression ')' expected qlikview

vishsaggi — Wed, 20 Sep 2017 12:54:14 GMT

= 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.

Re: error in expression ')' expected qlikview

sunny_talwar — Wed, 20 Sep 2017 12:54:30 GMT

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')))

Re: Error in Expression

mostwanted123 — Wed, 20 Sep 2017 12:54:40 GMT

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

Re: error in expression ')' expected qlikview

suryaa30 — Wed, 20 Sep 2017 12:57:58 GMT

Hi Vishwarath,

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

Re: error in expression ')' expected qlikview

vishsaggi — Wed, 20 Sep 2017 13:00:51 GMT

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

Re: error in expression ')' expected qlikview

suryaa30 — Wed, 20 Sep 2017 13:01:40 GMT

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

Re: error in expression ')' expected qlikview

hari8088 — Wed, 20 Sep 2017 13:02:49 GMT

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')))

Re: error in expression ')' expected qlikview

sunny_talwar — Wed, 20 Sep 2017 13:03:38 GMT

If condition in qlik cannot be like this

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

A < x and x < B

Re: error in expression ')' expected qlikview

suryaa30 — Wed, 20 Sep 2017 13:07:46 GMT

Thanks Much Sunny