Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

michielvandegoo
Valued Contributor

Line chart, 2 dimensions, % by dimension

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-7546792983-123%
2014-2-6646769255-104%
2014-3-6528975750-116%
2014-4-6751868635-102%
2014-5-7982667569-85%
2014-6-5544975806-137%
2014-7-6076967175-111%
2014-8-7304664482-88%
2014-9-6151745214-73%
2014-10-4610870902-154%
2014-11-88217864-1%
2014-12-123808147240-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.

2 Replies

Re: Line chart, 2 dimensions, % by dimension

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?

talk is cheap, supply exceeds demand
michielvandegoo
Valued Contributor

Re: Line chart, 2 dimensions, % by dimension

Gysbert,

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

Regards

Community Browser