Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
newqlik2017
Creator II

Round a decimal negative number

Capture3.PNG

Final table is my initial output.

Result table is my final output.

Name is my dimension and rest of the columns are derived from a single expression (with set analysis). C1-C4 needs to be in $ format. Last 3 columns needs to be in %. This example is in excel. I need this in Qlikview. I got all parts covered, except the negative decimal numbers which I can't get into single digit percent, like in column (C4/C3) - 1.

Any ideas?

2 Solutions

Accepted Solutions
swuehl
MVP

A simple format might do what you want:

=Num( YourCurrentExpression ,'0%')

View solution in original post

lorenzoconforti
Specialist II

Try changing # with 0

View solution in original post

11 Replies
swuehl
MVP

How do you get to -6% by calculating 200/400 -1 ?

swuehl
MVP

A simple format might do what you want:

=Num( YourCurrentExpression ,'0%')

newqlik2017
Creator II
Author

Capture3.PNG

That was a typo, in my original post, while copying from FINAL to RESULT table.

newqlik2017
Creator II
Author

Capture4.PNG

Hi Stephan, that works for case 1 (left side text boxes) but doesn't work for case 2 (right side text boxes).

lorenzoconforti
Specialist II

Can you post the exact expression behind the bottom right box?

newqlik2017
Creator II
Author

Capture5.PNG

Here's the expression used =num(787 / 853 - 1, '#%') as in text box above. The result of text box 1, when applied this expression is text box 2. Ideally, I'm looking for 11% as the result.

lorenzoconforti
Specialist II

Try changing # with 0

newqlik2017
Creator II
Author

= num ( (465/522-1), '#.%' )

This trick solved my issue. I needed a decimal before %.

newqlik2017
Creator II
Author

Both Stephan and Lorenzo's solution does work, including mine. Is there a way to award multiple answers as correct?