topic Data format on a Dimension field in QlikView

Data format on a Dimension field

Tue, 19 Jan 2010 17:12:26 GMT

We have a field on an SQL table that has a value of 0.0293. When I use this field in a pivot table as a dimension field it shows 0.03. How do I get it to show 0.0293?

Thanks,

LMAS

Data format on a Dimension field

mike_garcia — Tue, 19 Jan 2010 17:14:21 GMT

Maybe with a calculated dimension using the num function...

Data format on a Dimension field

Miguel_Angel_Baeyens — Tue, 19 Jan 2010 17:17:49 GMT

As pointed out by Mike, use

Num(YourField, '#,000')

Quoted text is the format of the field. Hope this helps

Data format on a Dimension field

Tue, 19 Jan 2010 17:38:36 GMT

Thanks, for the quick response. That did give me what I was looking for.

LMAS