topic Re: text format in dimenesion in QlikView

text format in dimenesion

Anonymous — Sun, 17 Mar 2013 13:59:06 GMT

hi,

i have dimenesion feild in pivot like this : 2.415687651321

what i need to write in the text format ?

i wrote like this but nathing happened.

=num(([filed]),'#,##0')

thanks,

yarin.

nagaiank — Sun, 17 Mar 2013 14:03:19 GMT

You may try using a calculated dimension with an expression like

Round(Num([field])

Anonymous — Sun, 17 Mar 2013 14:07:08 GMT

thank's

but still nathing heppened.

i need that feild will be 2.41.

thanks'

Sun, 17 Mar 2013 14:50:42 GMT

can you try this?

=num([Field Name],'#0.00')