topic Re: Understanding the parallel coordinates chart in QlikView

Understanding the parallel coordinates chart

Fri, 11 May 2012 12:54:29 GMT

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

Understanding the parallel coordinates chart

Anonymous — Fri, 11 May 2012 13:31:25 GMT

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

Understanding the parallel coordinates chart

Fri, 11 May 2012 13:39:47 GMT

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

Understanding the parallel coordinates chart

Anonymous — Fri, 11 May 2012 14:13:45 GMT

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

Understanding the parallel coordinates chart

Fri, 11 May 2012 17:33:19 GMT

Hello Michael,

It worked!!

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

Kind regards,

Erich

Re: Understanding the parallel coordinates chart

Wed, 28 Nov 2012 13:45:00 GMT

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?

Re: Understanding the parallel coordinates chart

sudeepkm — Thu, 17 Oct 2013 09:39:40 GMT

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

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

Re: Understanding the parallel coordinates chart

Anonymous — Fri, 18 Oct 2013 15:31:37 GMT

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

Re: Understanding the parallel coordinates chart

Mon, 18 Nov 2013 09:10:16 GMT

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

Re: Understanding the parallel coordinates chart

Anonymous — Mon, 18 Nov 2013 13:50:58 GMT

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

Re: Understanding the parallel coordinates chart

Tue, 26 May 2015 13:37:52 GMT

Hi Michael ,

i have replicated the chart , but i am facing a difficulty .

On selecting some fields the node percentages vanishes , can you please elaborate ???

i really intend to understand the expression in detail

help really appreciated

Re: Understanding the parallel coordinates chart

Fri, 29 May 2015 11:09:30 GMT

can somebody elaborate the color here

i want the lines to be of three colours instaed of two based on the customer response as Good , Bad , Statisfactory .

how should i do that

when i give the variable in the exprsession the field name it just shows black lines .