Script for Extension

[Anonymous]

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,"|")) & ' " '

[its_anandrjs]

Hi,

Try this sexpression

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

'"width":"2",'& 

'"style":"straight",'& 

'"line":"solid",'&

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

Regards

Anand

[its_anandrjs]

And this one

='"color":#42CB10",

  "width":"2", 

  "style":"straight", 

  "line":"solid",

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

Regards

Anand