Number Format.

Architect — Sat, 16 Nov 2024 18:47:50 GMT

HI,

I just encountered one problem here. For an expression

While using '# ##0,0%' as number format , result is 74,8%

but making it '# ##0.0%' and result becomes 74.0%. can someone please explain why.

Below is the full expression:-

if(match(getcurrentfield(Range_Structure),'RU','Purchasing Area (POA)','Purchasing Team','Supplier','Purchasing Group','Range Status')=0,

(num(Count({<[Range Status]=,SnapNo={1}, HAVE_ASSESMENT={1},[Item Status]={Sellable}>}DISTINCT [Item No])
/
Count({<[Range Status]=,SnapNo={1}, HAVE_ASSESMENT=,[Item Status]={Sellable}>}DISTINCT [Item No])
,'# ##0,0%')),'')

Re: Number Format.

Vegar — Sat, 11 Apr 2020 19:26:21 GMT

It depends on our variable

SET DecimalSep=',';

If you wan't to present the value with an '.' as decimal you can do like this (using hte third parameter in num():

=num(Expression1 ,'# ##0.0%', '.')

topic Number Format. in QlikView

Number Format.

Re: Number Format.