topic Re: How to format numbers in straight table? in QlikView

How to format numbers in straight table?

Fri, 31 Jan 2014 13:18:52 GMT

Hi,

I'm struggling to format numbers in a straight table - I have figures like "11,121412341" in several columns. There doesn't seem to be a way to format it.

Is there any way to get around it? If I switch to pivot table I only see my "expression" and I need to have all columns visible all time.

Would it make sense to round figures at a script level? That would probably impact the value of my calculations? Perhaps there is a way to trim the values somehow?

Best regards,

CaptainP

Re: How to format numbers in straight table?

Fri, 31 Jan 2014 13:22:10 GMT

Hi CaptainP

You can set formatting for dimensions in Document Preferences => Number

Lukasz

Re: How to format numbers in straight table?

jvishnuram — Fri, 31 Jan 2014 13:23:24 GMT

Hi Captain,

your figures in expression or dimension, if it is in expression it should show in the number tab. or let me know if my understanding is wrong about your requirement.

Re: How to format numbers in straight table?

Anonymous — Fri, 31 Jan 2014 13:25:03 GMT

CaptainP

Have you tried using a Calculated Dimension, as in something like :

=round( [YourField] )

Best Regards, Bill

Re: How to format numbers in straight table?

johnca — Fri, 31 Jan 2014 13:26:08 GMT

In a straight table formatting is controlled on the Numbers tab. Highlight the desired field and select Override Document settings, then depending on your requirements, select Fixed To and set the Decimal selector to 1 or 2 (or?). Another possibility is to use Integer, Number or Money selections.

HTH,

--john

Re: How to format numbers in straight table?

Fri, 31 Jan 2014 13:30:11 GMT

Łukasz,

works perfectly

Thanks

CaptainP