Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Node_Percent Error

Hi friends,

I am trying  parrallel coordinates plot. I am getting error at node_percent.

dual(

$(=concat('if($Field='&chr(39)&$Field&chr(39)&',concat(distinct ['&$Field&']))','&'))&'

'&num( 100*node_percent, '#,##0.#', '.' , ',' )&'%'

,

$(=concat('if(textcount(total ['&$Field&'])=0,if($Field='&chr(39)&$Field&chr(39)&',0.1+((min(['&$Field&'])-min(total ['&$Field&']))/(max(total ['&$Field&'])-min(total ['&$Field&']))),0),if($Field='&chr(39)&$Field&chr(39)&',0.1+((aggr(nodistinct rank(['&$Field&'],4),['&$Field&'])-1)/rangemax( (count(distinct total ['&$Field&'])-1) ,1 )),0))','+'))

)

Please help me where i am going wrong.

Thanks

Pavan

Tags (1)
1 Reply
vikasmahajan
Honored Contributor III

Re: Node_Percent Error

check with filed name node_percent or variable you have created ?

Vikas

Community Browser