Expression Error

[Anonymous]

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

[m_woolf]

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

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

[Anonymous]

Hi,

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

Regards