topic Re: simple line chart not working in QlikView

simple line chart not working

Tue, 12 Nov 2013 12:33:20 GMT

Hi all,

I am trying to make a simple line chart but it does not seem to work.

Athough it shows the data as a straight table the line chart does not render.

See attached example.

Regards.

kaushiknsolanki — Tue, 12 Nov 2013 12:39:52 GMT

Hi,

This is because the TourqueValue is not in Number format, its in string format.

Do following change in the script.

Use the Num#() Function, to change string to number

TorqueData:

LOAD id,

serial,

firmware,

SubField(TorqueVal,',',1) as Turn,

num#(SubField(TorqueVal,',',2)) as TorqueValue,

TestDate

Resident TorqueDataTmp;

Regards,

Kaushik Solanki

Clever_Anjos — Tue, 12 Nov 2013 12:40:52 GMT

Your "TorqueValue" is loading as a text

Change

SubField(TorqueVal,',',2) as TorqueValue,

into

num#(trim(SubField(TorqueVal,',',2))) as TorqueValue,

Another point is that you need a aggregation function into your graph, maybe SUM() will fit

Tue, 12 Nov 2013 13:16:45 GMT

Thaks you both of you for the quick reply.

How haven't I notice. Hmm its probably the lack of sleep