Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Revenue and % change in one chart

Hi,

I'm trying to build a chart (like the one below) showing montly revenues and % change but I cannot get the right expression of the change. Any ideas?

Regards,

Ivelin

Tags (1)
1 Solution

Accepted Solutions

Re: Revenue and % change in one chart

revenue: sum(revenue)

% change: sum(revenue)/above(sum(revenue))-1

You'll have to use a secondary axis for the % change expression or you'll have a line hovering between 0 and 1

Also you won't have a % change value for the first year


talk is cheap, supply exceeds demand
2 Replies

Re: Revenue and % change in one chart

revenue: sum(revenue)

% change: sum(revenue)/above(sum(revenue))-1

You'll have to use a secondary axis for the % change expression or you'll have a line hovering between 0 and 1

Also you won't have a % change value for the first year


talk is cheap, supply exceeds demand
Not applicable

Re: Revenue and % change in one chart

Thanks Gysbert!

Community Browser