topic Re: % Increase On Text object. in QlikView

% Increase On Text object.

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

Hi QV Team,

I have following text objects respectively.

For "IO YTD" 2017 this is the expression: num(sum({<FactType={IO},Jahr={$(vAY)},Monat={$(vActualMonth)},Tag={"<=$(vDayToday)"}>}NET_VALUE_IN_EUR),'#.##0') Answer: 66.513878

For "IO YTD" 2016 this is the expression: num(sum({<FactType={IO},Jahr={$(vAY)},Monat={$(vActualMonth)},Tag={"<=$(vDayToday)"}>}NET_VALUE_IN_EUR),'#.##0') Answer: 718.087.840

Now I need an expression to calculate the Percentage increase or decrease of 2017 vs 2016.

Need Help!

Re: % Increase On Text object.

sushil353 — Tue, 07 Mar 2017 06:28:36 GMT

Hi,

For IO YTD.

Try this:

num((sum({<FactType={IO},Jahr={$(vAY)},Monat={$(vActualMonth)},Tag={"<=$(vDayToday)"}>}NET_VALUE_IN_EUR)

/sum({<FactType={IO},Jahr={$(vAY)},Monat={$(vActualMonth)},Tag={"<=$(vDayToday)"}>}NET_VALUE_IN_EUR))-1.'#,##0%')

HTH

Sushil

Re: % Increase On Text object.

muthukumar77 — Tue, 07 Mar 2017 06:31:07 GMT

(Year2017-Year2016)/Year2017

if output come as negative, Decrease.

if output come as Positive, Increase.