Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MuraliPrasath
Creator III
Creator III

% Increase On Text object.

Hi QV Team,

I have following text objects respectively.

Capture.PNG

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!

2 Replies
sushil353
Master II
Master II

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

muthukumar77
Partner - Creator III
Partner - Creator III

(Year2017-Year2016)/Year2017

if output come as negative, Decrease.

if output come as Positive, Increase.

Muthukumar Pandiyan