topic Line chart axis changes in QlikView

Line chart axis changes

Fri, 08 Jan 2016 08:03:26 GMT

Hi I have line chart currently which shows Original Budget and Current Budget by month for a financial year, see the attached example.

Now I want to show a line chart with the combined totals for the year for Original and Current Budget, something like the attached example in the New file

I have tried making the Original and Current dimensions, but somehow it's just not putting them next to each other with a line between them as in the second example. What am I missing?

Re: Line chart axis changes

effinty2112 — Fri, 08 Jan 2016 08:13:52 GMT

Hi Andret,

Original and Current shouldn't be dimensions. The dimension you need will be Budget with two values 'Original' and 'Current'.

If that's what you meant to say and you've tried it already and it's not working then post your data and I'm sure a solution will be found.

Cheers

Re: Line chart axis changes

Fri, 08 Jan 2016 09:04:09 GMT

Example is attached. Note the example of how I need to see this in the new image file

Re: Line chart axis changes

jagan — Fri, 08 Jan 2016 09:26:17 GMT

Hi,

Please find attached file for solution.

Regards,

jagan.

Re: Line chart axis changes

effinty2112 — Fri, 08 Jan 2016 09:44:53 GMT

Hi Andret,

Having a Crosstable in your load script will make the chart easy to produce:

CTData:

CrossTable(Budget,Data)

LOAD * Resident Data;

This gives this straight table:

Budget	sum(Data)
	3114
Original	2136
Current	978

or a line chart:

Re: Line chart axis changes

Fri, 08 Jan 2016 10:03:55 GMT

Thanks for this. I have so much data manipulation at this stage so it's really confusing script wise, adding this will just over complicate it for me at this stage. I do this the solution is really great. I have used similar ways to get my data easier to work with. I think it works just as well probably as the other solution. Just for my specific needs this just gets too much to get the data correct for all possible graphs I have to produce.

Thanks a million though

Re: Line chart axis changes

Fri, 08 Jan 2016 10:05:19 GMT

Works perfectly for me with the data I have.

Thanks