topic Decimal Formating in QlikView

Decimal Formating

Fri, 08 Jul 2011 23:34:37 GMT

I have a column of data that is formated as a percentage but I want the decimal places to the left to format dynamically. Meaning, if the number is 5.234% then three decimals to the right will show, however, if the number is 5.5% then I only want one decimal to the right to show. The "Number" tab only allows me to set a fixed number of decimals to the right.

Thanks,

Stephen

Re: Decimal Formating

johnw — Fri, 08 Jul 2011 23:40:12 GMT

Hmmm, weird that it isn't directly supported. This would probably work when using "expression default" as your numeric format.

dual(100*sum(A)/sum(B)&'%',sum(A)/sum(B))

Re: Decimal Formating

nagaiank — Sat, 09 Jul 2011 14:01:16 GMT

If no standard is followed for display of numbers, will it be acceptable if you end up in numbers like those listed below?

3.33333333333333%

12345678.9012345%

1234567890123.45%