# Qlik Sense App Development

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for
Did you mean:
Highlighted
Master

## How to make -125.8% display as +100% ?

Hi All

I have a expression.

(

sum({\$<nET_PROFIT={'nET_PROFIT'}, date={">=\$(=num(YearStart(Today())))<=\$(=num(Today()))"}>} Amount*-1/1000)

-

)

/

Now mu issue is when 2015 net profit amount -ve and 2016 net profit amount +ve , it display -ve % , which is wrong , i like to make it display 100%.

Hope some one can advise me.

Paul

7 Replies
Highlighted
Master

my QVF

Highlighted
MVP

Why would you see a 100%? Is this in general that any time you have a negative %age, you would want to see 100%?

Highlighted
Master

Hi Sunny

I am think if it is able see +ve % I am

Fine.

As it is not easy to compute to show the actual % growth from -ve to + ve.

Paul

Get Outlook for iOS<https://aka.ms/o0ukef>

Highlighted
Champion II

i think you have reused an expression to show amount in \$000's that's why dividing by 1000!

but you don't need that for the percentage calculation.

Also if the increase / decrease percentage is -125% or +125% you should show it as it is instead of ceiling to 100%

(

sum({\$<nET_PROFIT={'nET_PROFIT'}, date={">=\$(=num(YearStart(Today())))<=\$(=num(Today()))"}>} Amount)

-

)

/

Highlighted
Master

Hi Vineeth

If you see carefully , the bar chart , shown that profit for 2015 was -ve value , and 2016 was +ve value.

the fact is that logically the % should be +ve , but your expression is still show -ve.

Paul

Highlighted
Champion II

Hi Paul,

Recheck your expression for profit, you are multiplying it with -1.

What is the purpose of multiplying profit with -1?

Highlighted
Master

Hi Vineeth

You are right , the -ve sign should not be there ,  i think i accidently enter in , which is wrong. after i remove the -ve sign.

Now after remove the -ve sign. but for TDSID , how to make it display +ve % ?

Paul