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

Decimal value less than 1% gives me wrong %.

Tue, 10 Sep 2013 09:18:18 GMT

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

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

Tue, 10 Sep 2013 09:20:43 GMT

Hi,

Try this format '##0.00%'

It will work.

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

Tue, 10 Sep 2013 09:35:28 GMT

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

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

swuehl — Tue, 10 Sep 2013 09:35:49 GMT

Can't reproduce this here with 11.2 SR3:

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

in a text box shows 0.10%

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

michael_maeuser — Tue, 10 Sep 2013 09:37:23 GMT

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

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

Tue, 10 Sep 2013 09:37:47 GMT

Hi,

Try this, '#,##0.00'.

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

Tue, 10 Sep 2013 09:52:44 GMT

Hi,

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

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

christian77 — Tue, 10 Sep 2013 09:57:33 GMT

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.

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

Tue, 10 Sep 2013 09:58:10 GMT

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?

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

michael_maeuser — Tue, 10 Sep 2013 09:59:45 GMT

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

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

Tue, 10 Sep 2013 10:05:48 GMT

Chirstian, i get 260,65%. Which exceeds more than 100. Still not getting to find solution

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

christian77 — Tue, 10 Sep 2013 10:06:44 GMT

To build a calculated dimension, the object has to understand what are you dimensionning. Therefore, enclose your expression in an aggr funcktion like:

aggr(if(Month>3, Month), Month)

That way the object knows what dimension you want exactly. In this case it'll show months.

aggr(if(Month>3, Week), Month) or aggr(if(Month>3, Week), Week)

Some people don't like calculated dimensions cause the take longer time to calculate. I think depends on what dimension we use. It's is better to have it on the script. Sometimes I don't want to touch the script for only a table.

good luck.

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

christian77 — Tue, 10 Sep 2013 10:13:23 GMT

Go to the script and see how is yor var definition at the top of the first page. Is it in Spanish?

Go to document properties and in the tab Number, check the quality of your data.
If you're getting undesired data formats, control that at the script by appling funcktions to set the correct formats.

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

Tue, 10 Sep 2013 10:16:29 GMT

Many thanks. It worked now