topic Re: Script for Extension in QlikView

Script for Extension

Anonymous — Fri, 14 Nov 2014 19:53:31 GMT

Hello Qlik Community,

I am trying to write an expression for a QV extension. It says error expression but I have mirrored it to the sample script provided. Can anyone notice anything wrong with it. The leading parenthesis in front of concat is red. If I add another ending parenthesis it errors out the ' " ' at the end of the script. Thanks

Mine:

=' "color":#42CB10",

"width":"2",

"style":"straight",

"line":"solid",

"children":" ' & (concat(if(len(field)>0, field,field2,'|')) & ' " '

Sample:

=' "color":"4#2CB10",

"width":"2",

"style":"straight",

"line":"dashed",

"children":" ' & (concat(DISTINCT TOTAL Store ID,"|")) & ' " '

Re: Script for Extension

its_anandrjs — Fri, 14 Nov 2014 20:14:14 GMT

Hi,

Try this sexpression

='"color":#42CB10",'&

'"width":"2",'&

'"style":"straight",'&

'"line":"solid",'&

'"children":" '&concat(if(len(field) > 0, field,field2),'|') & ' " '

Regards

Anand

Re: Script for Extension

its_anandrjs — Fri, 14 Nov 2014 20:16:18 GMT

And this one

='"color":#42CB10",

"width":"2",

"style":"straight",

"line":"solid",

"children":" '& concat(if(len(field) > 0, field,field2),'|') & ' " '

Regards

Anand