Discussion Board for collaboration on QlikView Layout & Visualizations.
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?
Go to Solution.
% 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