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
Specialist III
Specialist III

show in two decimal

Hi  all,

Jyothish KC

Frank Hartmann

i have a column  name is rate  and now values showing as  100.00000455  [ this column is coming from directly from DB]

i want to  get as a  new column with  100.00%

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Hi Sony, maybe this

Num(100.00000455, '#,##0.00') & '%'

or this

Num(100.00000455/100, '#,##0.00%')

View solution in original post

4 Replies
Highlighted
Specialist
Specialist

Hi Sony, maybe this

Num(100.00000455, '#,##0.00') & '%'

or this

Num(100.00000455/100, '#,##0.00%')

View solution in original post

Highlighted
Specialist III
Specialist III

thanks for your response.  second one looks cool

can you have look on below thread.

range

Highlighted
Master II
Master II

try this:

num(round(100.00000455,0.01)/100,'#.##%')

Highlighted
Specialist III
Specialist III

but it is showing all 100.00% only... as i have data like 99.988  it should not round.

it should show 99.98% ..

and can u have a look into this?

range