Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think you need an "=" sign in front of the "if":
vTableKPI ='=if(KPIs='&chr(39)& con
Hi,
Thanks for your answer but I think there's something wrong in my formula.
Regards