Parallel Coordinates Graph F

[#1]

When trying to make a parallel coordinates graph as described in QlikVIew Cookbook, the field 'Metric' is not calculated:

LOAD @1:10 As MetricCode,

Trim(SubField(SubField(@11:115, ':', 2), ',', 1)) as Metric,

@116:119 as Unit,

@120:128 as Decimal,

@129:140 as US_Total,

@141:152 as Minimum,

@153:164 as Maximum,

@165:n as Source

FROM

DataDict.txt

(fix, codepage is 1252, embedded labels);

Is that some kind of bug, or do I have to set something different? Comma or : or something else?

[ashfaq_haseeb]

Hi,

have a look at below posts.

http://community.qlik.com/message/202073#202073

http://community.qlik.com/message/585961#585961

http://community.qlik.com/thread/53191

Regards

ASHFAQ

[#3]

I appreciate the links.
My plan was to make a graph with the tutorial from the book.
It would be very helpful if you could help me to get the 'Metric' field.

[#4 · Accepted solution]

Changinf the decimal seperatior and 2->1 in the expression helped