Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Decimal value less than 1% gives me wrong %.

Hello, I need help. I am using this '##.#0%' to show XX.XX% format for my column. But when it becomes less than 1%, lets say 0.95% it should show me 0.95%. But its showing me 95%. Anyone

1 Solution

Accepted Solutions
christian77
Valued Contributor

Re: Decimal value less than 1% gives me wrong %.


Hi:

Try this one instead '#.##0,00%' or  '#.##0,00 %' to have a nice space if you can.

I use this cause I use spanish notation.

13 Replies
Not applicable

Re: Decimal value less than 1% gives me wrong %.

Hi,

Try this format '##0.00%'

It will work.

Not applicable

Re: Decimal value less than 1% gives me wrong %.

It works absolutely fine. But one thing, i need to represent Dot (.) with Comma (,) in percentage. How can this be possible?    

MVP
MVP

Re: Decimal value less than 1% gives me wrong %.

Can't reproduce this here with 11.2 SR3:

=num(0.001,'##.#0%','.',',' )

in a text box shows 0.10%

michael_maeuser
Contributor III

Re: Decimal value less than 1% gives me wrong %.

go into the object properties. tab "numbers" there you can change it

Not applicable

Re: Decimal value less than 1% gives me wrong %.

Hi,

Try this, '#,##0.00'.

Not applicable

Re: Decimal value less than 1% gives me wrong %.

Hi,

Try this, '#,##0.00%'.

christian77
Valued Contributor

Re: Decimal value less than 1% gives me wrong %.


Hi:

Try this one instead '#.##0,00%' or  '#.##0,00 %' to have a nice space if you can.

I use this cause I use spanish notation.

Not applicable

Re: Decimal value less than 1% gives me wrong %.

Couldn't get the desired output as 0,96%. Remember, I'm using it in Calculated Dimension, so there's no option for dimensions to change through object properties, only Expression have. Anyone again?

michael_maeuser
Contributor III

Re: Decimal value less than 1% gives me wrong %.

you can change it generally in the script. there are some SET variables. take a look at ThousandSep , DecimalSep

Community Browser