topic Re: Number formatting in QlikView

Number formatting

Thu, 21 Jan 2016 02:16:07 GMT

I have expression like below,

If(GetFieldSelections(Measure)='SQF',

num((Sum({$<[Type] = {'Used'} >}[SF])),'#,##Sf'),

num((Sum({$<[Type] = {'Used'} >}[SF]*(0.9203))),'#,##Sqm'))

Now,when I set the number to expression default I am getting value something like 1.15E+0.007 and if I set the number to fixed to 0 decimals I dont get Sf or Sqm in front of the number.

Any suggestion/help is much appreciated.

Re: Number formatting

Rajamohan — Thu, 21 Jan 2016 02:22:49 GMT

Try to use & to concatenate symbol with numbers.

- Mohan

Re: Number formatting

engishfaque — Thu, 21 Jan 2016 03:29:08 GMT

Dear Pavana,

Kindly find attached file, I hope you are looking for that one solution.

Kind regards,

Ishfaque Ahmed

Re: Number formatting

PrashantSangle — Thu, 21 Jan 2016 04:12:23 GMT

Hi,

Try

If(GetFieldSelections(Measure)='SQF',

num((Sum({$<[Type] = {'Used'} >}[SF])),'#,00 Sf'),

num((Sum({$<[Type] = {'Used'} >}[SF]*(0.9203))),'#,00 Sqm'))

Try

If(GetFieldSelections(Measure)='SQF',

num(Floor(Sum({$<[Type] = {'Used'} >}[SF])),'#,00 Sf'),

num(Floor(Sum({$<[Type] = {'Used'} >}[SF]*(0.9203))),'#,00 Sqm'))

You can use Floor, Round, Ceil function as per requirement

If you want Sf or Sqm in front of the number.

then

If(GetFieldSelections(Measure)='SQF',

num((Sum({$<[Type] = {'Used'} >}[SF])),'Sf #,00'),

num((Sum({$<[Type] = {'Used'} >}[SF]*(0.9203))),'Sqm #,00'))

Note : GetFieldSelections() work when you select field value in Measure.

Regards,

Re: Number formatting

HirisH_V7 — Thu, 21 Jan 2016 08:07:16 GMT

Hi,

You can use expression like this,

=Num(Sum(Value), '#,##0.00 Sqm')

=Num(Sum(Value), '#,##0.00 Sf')

Is your Value format is in exponential??

Then in edit script,

Num(YourValue, '(dec)') as Value

HTH,

Hirish