topic Re: Number Formatting in QlikView

Number Formatting

Thu, 14 Aug 2014 10:40:55 GMT

Hi,

In one of my chart in qlikview application I formatted the number as fixed to two decimals and it is showing like 0.02,0.06 .....

I would like to see this as .02,.06....I have seen in few applications in this way but unfortunately couldn't replicate.

please help me in acheving this

Thanks

Murali Krishna

Re: Number Formatting

Gysbert_Wassenaar — Thu, 14 Aug 2014 10:53:13 GMT

The only way I can think of right now is by creating text values from them using the replace function. Something like replace(num(sum(Amount)),'.00'),'0.','.')

Re: Number Formatting

aveeeeeee7en — Thu, 14 Aug 2014 10:55:56 GMT

Try this:

if(Subfield(Num(Number,'#,##0.00'),'.',2)>=0,'.'&Subfield(Num(Number,'#,##0.00'),'.',2))

Also, see the Attachment.

Regards

Aviral Nag

Re: Number Formatting

MarcoWedel — Thu, 14 Aug 2014 11:19:27 GMT

Maybe extended to:

Dual(replace(num(sum(Amount)),'.00'),'0.','.'), sum(Amount))

Regards

Marco