topic Re: Line chart, 2 dimensions, % by dimension in QlikView

Line chart, 2 dimensions, % by dimension

Michiel_QV_Fan — Mon, 06 Jul 2015 07:54:55 GMT

I need to show the relation in % for 1 dimension over time.

On the x axis I show time.

Jaar maand	Klant	Overig	Overig/Klant

2014-1	-75467	92983	-123%
2014-2	-66467	69255	-104%
2014-3	-65289	75750	-116%
2014-4	-67518	68635	-102%
2014-5	-79826	67569	-85%
2014-6	-55449	75806	-137%
2014-7	-60769	67175	-111%
2014-8	-73046	64482	-88%
2014-9	-61517	45214	-73%
2014-10	-46108	70902	-154%
2014-11	-88217	864	-1%
2014-12	-123808	147240	-119%

I need a stacked line chart over a second dimension and over time.

I have the %relation ship in this straight table with this expression for the month:

aggr(sum({<%C_code = {'1'}>} Mutatie),[Jaar maand] )/aggr(sum({<%C_code = -{'1'}>} Mutatie),[Jaar maand] )

But I can't find a way to show this in the line chart. Values are calculated over the total value selected and I need these for each month recalculated.

In the line chart:

Each month = 100%

C_code 1 is the divider

C_code <> 1 are the values to be divided.

Re: Line chart, 2 dimensions, % by dimension

Gysbert_Wassenaar — Mon, 06 Jul 2015 13:58:13 GMT

I'm afraid I don't understand what you're trying to do.

What is a stacked line chart?
You mention a second dimension. The data you posted seems to have only one dimension. Can you explain about this second dimension?
What does "Values are calculated over the total value selected" mean?

Re: Line chart, 2 dimensions, % by dimension

Michiel_QV_Fan — Tue, 07 Jul 2015 07:18:38 GMT

Gysbert,

We changed the requirement to be able to show the data in a different way.

Regards