Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dinicholls
Creator II
Creator II

Line Chart - Line not Making Sense!

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

1 Solution

Accepted Solutions
jonathandienst
Partner
Partner

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

5 Replies
awhitfield
Partner
Partner

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

awhitfield
Partner
Partner

Also, could you posted the actual QVW?

Anonymous
Not applicable

have you tried to change the order of your dimensions?

jonathandienst
Partner
Partner

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
Creator II
Creator II
Author

Thank You Jonathan!

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

Di