topic Calculate the % change Sales in QlikView

Calculate the % change Sales

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

Hello,

I created the calculation of % Change Sales, with the function Above is right when he made no selection.

But when I select a year, I lose the calculation of the previous year

Year	Sales	Last Year's Sales	% Change
2014	3250	-	-

Please, if you have another way to do this calculation.

Thanks in advance...!!!

Regards,

Tue, 27 Sep 2016 18:00:15 GMT

I need to do the same!

el_aprendiz111 — Tue, 27 Sep 2016 21:53:18 GMT

Hi,

sunny_talwar — Wed, 28 Sep 2016 01:41:54 GMT

May be try these expressions

1) =Sum({$< CONCEPT={'Sale'}>} AMOUNT)

2) =Above(Sum({$<CONCEPT={'Sale'}, YEAR>}AMOUNT)) * Avg(1)

3) =([Sales]/Above(Sum({$<CONCEPT={'Sale'}, YEAR>}AMOUNT))-1) * Avg(1)