SWitching axis

[#1]

Hi

Please see attached app and screenshots.

We want to display cost by month but importantly as a line graph. Works as is as a bar chart.

When a line graph is selected it is only showing one series of data - in this case Dec.

Can someone please advise and explain how to get this to work?

Much appreciated.

Chris

[swuehl]

I believe there are actually two months shown, but with almost identical values...

[ThornOfCrowns]

If you plot the chart using symbols., you'll see that you have the same data for each month, so it shows as a single overlapped point in the line chart.

[#4]

Hi,

Yes values are very similar but we want the months to show along the bottom as the x axis and be spaced out like it looks on a bar chart. The answer would be to be able to switch the series and axis around. So at the moment the series is 'month' and x axis 'total'.

Can this not be switched so series is 'total' and x axis 'month'?

Chris

[#5]

Hi,

This is how it works in excel - simple line chart based on selected data - how can this be replicated in Qlikview?

Chris

[swuehl]

Just use only one dimension, your Month field.

[#7]

sweuhl

To clarify do this on the chart properties - dimensions tab?

But there is 12 months?

I have transposed the data in excel and loaded that and now the line chart works