Expression Error

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All, I am new in QlikView.

My problem is instead to have the result of my expression, the expression is displayed.

You can see below my formula.

vTableKPI ='if(KPIs='&chr(39)& concat(KPIs &chr(39)&',$'&'(vKPI_'& KPIs,'),if(KPIs='& chr(39)) & ')' & KeepChar(concat(KPIs,')'),')')&')'

when I call vTableKPI in my object , I just have something like this :

if(KPIs='AFAI',$(vKPI_AFAI),

if(KPIs='AH',$(vKPI_AH),

if(KPIs='BOI',$(vKPI_BOI),

if(KPIs='BRCT',$(vKPI_BRCT),)))).

I would like to have the value of this expression and not display the expression.

Thanks for your help.

Regards

Re: Expression Error

m_woolf — Thu, 02 Aug 2018 17:36:10 GMT

I think you need an "=" sign in front of the "if":

vTableKPI ='=if(KPIs='&chr(39)& con

Anonymous — Fri, 03 Aug 2018 10:03:07 GMT

Hi,

Thanks for your answer but I think there's something wrong in my formula.

Regards