Understanding the parallel coordinates chart

[#1]

Hello,

A while a go i found an article about parallel coordinate charts at this site.

http://qvdesign.wordpress.com/2012/01/31/brilliant-qlikview-parallel-co-ordinates-chart/

I've managed to use the chart, it is a fantastic chart.

The problem is that the formula's are generic and make use of the $fields variable.

I have a application in wich i could use this kind of chart, the only thing is that i use a lot of fields so the user has to much possibilitys. Does anyone know a way to use a predetermined set of fields in the generic formulas?

Thank you in advance.

Erich van den heuvel

[Anonymous]

You can create a new field as logical data island, which contains the names of fields available for user.  After that either use this new field instead of the $Field in the chart (this would be my first choice), or use the same $Field with condition (or set expression) to use only the values from your list.

Regards,
Michael

[#3]

Hi Michael,

I think this is the way to do it, but..

I've never created a logical data island, at least not that i know of. Can you tel me how to do this? I think i need just about 6 fields from my total fieldlist.

Regards Erich

[Anonymous · Accepted solution]

Eric,

Here is an example:
LOAD * ININE [
NewField
Field1
Field2
Field3
Field4
Field5
Field6];

Where the NewField will be replacing $Field, and Field1 - Field6 are the names of the fields you're going to use.  "Logical Data island" means that there are no key fields, that is the NewField does not exist in any other table.

Regards,
Michael

[#5]

Hello Michael,

It worked!!

Thank you, wilth your answer i can use this chart in my applications.

Kind regards,

Erich

[#6]

I still have some trouble understanding this graph.  I got it to work with my data but what I don't undertstand is the expression 'line_percent'. Here's the part I don't understand:

max(total aggr(SUM(IF(Type = 'Claims',[Invoice Count],0)), $Field,[Customer Gender],[Customer Marital Status],Product, [Posting Year]))

Why is the last 5 rows there? I mean Gender, Marital status etc. Why these ones?

[sudeepkm]

are there any simple explanation available for the expressions used in the parallel coordinates chart?

=$(='if('&concat('NOT IsNull(['&$Field&'])',' AND ')&', hash128('& concat('['&$Field&']',',')&'))' )

[Anonymous]

There is nothing simple here, but you can better undersatnd the meaning of this calculated dimension if you create a text box, and copy this expression there, except the =$() part:

='if('&concat('NOT IsNull(['&$Field&'])',' AND ')&', hash128('& concat('['&$Field&']',',')&'))'

For a better explanation, ask the author of the chart...

Regards,

Michael

[#9]

Hi Michael,

I tried the script it fails and application get closed.

I want only these fields in my list.

Below is my script:

LOAD * INLINE [

$Field

Buyer Name

Claim Office

Claim Status

Country

OpenClaim_Month

OpenClaim_Quarter

OpenClaim_Year

];

What might be the reason?

Thanks in Advance,

Keerthi

[Anonymous]

Hi Keerthi,

Do not use field name $Field - it is a system reserved name.  Use something else, e.g. NewField, and use it instead of $Field in the chart.

Regards,

Michael