Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.','.')
Hi
Try this:
if(Subfield(Num(Number,'#,##0.00'),'.',2)>=0,'.'&Subfield(Num(Number,'#,##0.00'),'.',2))
Also, see the Attachment.
Regards
Aviral Nag
Maybe extended to:
Dual(replace(num(sum(Amount)),'.00'),'0.','.'), sum(Amount))
?
Regards
Marco