topic Re: Line Chart - Line not Making Sense! in QlikView

Line Chart - Line not Making Sense!

dinicholls — Fri, 20 Feb 2015 11:58:16 GMT

Hi,

I have a really basic line chart in my app.

Dimensions are Extract Date, and Company Name.

Expression is: sum([Account Balance]) as 'Line Debt'.

When I apply everything, the graph comes out like the first one in the attachment, when I want it to appear like the second one.

What am I doing wrong?! There are no filters or anything in my chart. The extract dates are exactly the same, and the dat is pulling from a single QVD file.

Any help appreciated!

Re: Line Chart - Line not Making Sense!

awhitfield — Fri, 20 Feb 2015 12:01:41 GMT

What do you mean by 'When I apply everything' please?

Re: Line Chart - Line not Making Sense!

awhitfield — Fri, 20 Feb 2015 12:03:58 GMT

Also, could you posted the actual QVW?

Re: Line Chart - Line not Making Sense!

Anonymous — Fri, 20 Feb 2015 12:05:41 GMT

have you tried to change the order of your dimensions?

Re: Line Chart - Line not Making Sense!

jonathandienst — Fri, 20 Feb 2015 12:06:51 GMT

Try continuous axes for the x axis in the chart.

There may be something odd about your dates - perhaps they have a time component. Use Date(Floor(ExtractDate)) to remove the time component.

HTH

Jonathan

Re: Line Chart - Line not Making Sense!

dinicholls — Fri, 20 Feb 2015 13:46:20 GMT

Thank You Jonathan!

I always forget there might be a time bit to it!