Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Parrallel Coordinates Chart!! Help me Please.

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.

0 Replies