Parrallel Coordinates Chart!! Help me Please.

Fri, 22 May 2015 15:06:23 GMT

Hey guys, I'm trying to apply the parrallel coordinates chart and have run into a few issues, I'll attach my data source spreadsheet and the qvw. file. This is basically a copy off of one of the two available here on the community site links. This seemed like the most plausable to recreate. Thanks Sudeep.

We have the chart going and the list boxes, but for some reason I can't get the node_percent expression to show the % values, they are all showing zero. I assume this is because my expression is resulting in zero, due to the numerator being zero for some reason, but I can't figure out why. My data set can't be the issue because it is very similar to sudeep's working version. Just stuck on this node_percent expression. It must be my data but can't figure out why....

=$(='(

aggr(

concat('if($Field='&chr(39)&$Field&chr(39)&',1,0)*

count(total <['&$Field&']> ID)

','

&', $Field, '&

concat('['&$Field&']',',')&')'

)

/count(total DealID)

)

This is the node_percent expression. It seems to have a 3 parameter aggr statement, which I've never seen. So its aggregating on $Field, and performing

if($Field='&chr(39)&$Field&chr(39)&',1,0)*

count(total <['&$Field&']> ID)

What does this mean?

Thanks in advance.

topic Parrallel Coordinates Chart!! Help me Please. in QlikView

Parrallel Coordinates Chart!! Help me Please.