Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
newqlik2017
Creator II
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
MVP

A simple format might do what you want:

=Num( YourCurrentExpression ,'0%')

View solution in original post

lorenzoconforti
Specialist II
Specialist II

Try changing # with 0

View solution in original post

11 Replies
swuehl
MVP
MVP

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

swuehl
MVP
MVP

A simple format might do what you want:

=Num( YourCurrentExpression ,'0%')

newqlik2017
Creator II
Creator II
Author

Capture3.PNG

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

newqlik2017
Creator II
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
Specialist II

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

newqlik2017
Creator II
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
Specialist II

Try changing # with 0

newqlik2017
Creator II
Creator II
Author

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

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

newqlik2017
Creator II
Creator II
Author

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