topic Re: SWitching axis in QlikView

SWitching axis

Tue, 19 Jan 2016 11:02:29 GMT

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

Re: SWitching axis

swuehl — Tue, 19 Jan 2016 11:06:41 GMT

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

Re: SWitching axis

ThornOfCrowns — Tue, 19 Jan 2016 11:18:16 GMT

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.

Re: SWitching axis

Tue, 19 Jan 2016 11:38:00 GMT

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

Re: SWitching axis

Wed, 20 Jan 2016 07:38:33 GMT

Hi,

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

Chris

Re: SWitching axis

swuehl — Wed, 20 Jan 2016 07:44:26 GMT

Just use only one dimension, your Month field.

Re: SWitching axis

Wed, 20 Jan 2016 07:53:52 GMT

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