topic Re: % Increase in combo chart in QlikView

% Increase in combo chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a chart and I would like to take last month and compare the the totals of the months after. For example 201605 to 201606 % increase from 18 to 49 is not 72% and 49 to 71 is definetly not a negative increase. Confused on what I'm doing wrong. I have attached a sample app.

Re: % Increase in combo chart

sunny_talwar — Mon, 18 Jul 2016 18:36:08 GMT

Try this:

Num(RangeSum(Above(Count({<STARTDATE= {"*2016*"}>} ID), 0, RowNo()))/RangeSum(ABOVE(Count({<STARTDATE= {"*2016*"}>} ID), 1, RowNo())) - 1, '#.00%')

Re: % Increase in combo chart

sunny_talwar — Mon, 18 Jul 2016 18:36:58 GMT

Sample attached