Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Understanding the parallel coordinates chart

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

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Understanding the parallel coordinates chart

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

View solution in original post

11 Replies
mov
Esteemed Contributor III

Understanding the parallel coordinates chart

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

Not applicable

Understanding the parallel coordinates chart

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

mov
Esteemed Contributor III

Understanding the parallel coordinates chart

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

View solution in original post

Not applicable

Understanding the parallel coordinates chart

Hello Michael,

It worked!!

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

Kind regards,

Erich

Not applicable

Re: Understanding the parallel coordinates chart

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
Valued Contributor III

Re: Understanding the parallel coordinates chart

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

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

mov
Esteemed Contributor III

Re: Understanding the parallel coordinates chart

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

Not applicable

Re: Understanding the parallel coordinates chart

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

mov
Esteemed Contributor III

Re: Understanding the parallel coordinates chart

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