Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Qlik: Rounding Errors

Hi,

I have a scenario where I am displaying percentages from a source column eg.:

27-01-2015 16-17-35.jpg

The values are just getting rounded off as I want to show the number as a percentage with 2 decimal places. I have been using the following syntax but it does not help:

Num(Source Value, ####.##)

What I am really looking for is the equivalent of a TRUNC function in Informatica where you could simply truncate upto 'n' decimal places. I am not sure if Ceil or Floor would help either. Please suggest

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

The floor function would be best for you, if you want it to 2 d.p. use Floor([Source Value], 0.0001) and then show in percentage at 2 d.p., and it should give you what you want.

View solution in original post

2 Replies
Highlighted
Specialist
Specialist

The floor function would be best for you, if you want it to 2 d.p. use Floor([Source Value], 0.0001) and then show in percentage at 2 d.p., and it should give you what you want.

View solution in original post

Highlighted
Not applicable

Great ! That worked perfectly