topic Re: Show comma only when value smaller than 1 in QlikView

Show comma only when value smaller than 1

christophebrock1 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I'm looking for the format pattern to convert a number into a number with a decimal, but only when the value goes below 1.

So for example:

0,9

0,3

Anyone has an idea?

Kind regards,

Christophe

Re: Show comma only when value smaller than 1

hic — Thu, 07 Jul 2016 09:38:52 GMT

Try

Num(Number,If(Number>=1,'0','0.0'),'.',',') as FormattedNumber

HIC

Re: Show comma only when value smaller than 1

hic — Thu, 07 Jul 2016 09:40:25 GMT

...or with decimal comma:

Num(Number,If(Number>=1,'0','0,0'),',','.') as FormattedNumber

Re: Show comma only when value smaller than 1

Chanty4u — Thu, 07 Jul 2016 09:42:05 GMT

try this

aa:

LOAD * INLINE [

sam, F2

0, 9

];

LOAD

if(sam<1,'0','0.0') as new

Resident aa;

Re: Show comma only when value smaller than 1

christophebrock1 — Thu, 07 Jul 2016 09:59:16 GMT

Thanks but I'm having these numbers generated in a barchart by selecting "Relative" (so I'm getting the percentages).

I want to format that "generated" number, as the load script doesn't work for me.

Re: Show comma only when value smaller than 1

hic — Thu, 07 Jul 2016 10:36:18 GMT

You can use the formula I suggested as expression in the bar chart:

Re: Show comma only when value smaller than 1

hic — Thu, 07 Jul 2016 10:43:46 GMT

But you may need to create the "relative" part inside your formula, e.g.

Re: Show comma only when value smaller than 1

christophebrock1 — Thu, 07 Jul 2016 10:49:42 GMT

Thanks, seems legit, but there's no easy formatting shortcode that can be used?

Re: Show comma only when value smaller than 1

hic — Thu, 07 Jul 2016 13:14:12 GMT

Unfortunately not...

Re: Show comma only when value smaller than 1

christophebrock1 — Thu, 07 Jul 2016 14:47:16 GMT

Ok, thanks for all the help !!