Solved: Line Chart - Line not Making Sense! - Qlik Community

dinicholls · ‎2015-02-20

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!

Di

jonathandienst · ‎2015-02-20

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

awhitfield · ‎2015-02-20

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

awhitfield · ‎2015-02-20

Also, could you posted the actual QVW?

Anonymous · ‎2015-02-20

have you tried to change the order of your dimensions?

jonathandienst · ‎2015-02-20

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

dinicholls · ‎2015-02-20

Thank You Jonathan!

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

Di