Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

A simple format might do what you want:

=Num( YourCurrentExpression ,'0%')

View solution in original post

Highlighted
Specialist II
Specialist II

Try changing # with 0

View solution in original post

11 Replies
Highlighted
MVP
MVP

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

Highlighted
MVP
MVP

A simple format might do what you want:

=Num( YourCurrentExpression ,'0%')

View solution in original post

Highlighted
Creator II
Creator II

Capture3.PNG

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

Highlighted
Creator II
Creator II

Capture4.PNG

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

Highlighted
Specialist II
Specialist II

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

Highlighted
Creator II
Creator II

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.

Highlighted
Specialist II
Specialist II

Try changing # with 0

View solution in original post

Highlighted
Creator II
Creator II

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

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

Highlighted
Creator II
Creator II

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