topic Text Format a dimension in a Pivot Table in QlikView

Text Format a dimension in a Pivot Table

Mon, 23 Aug 2010 11:42:57 GMT

Hi All,

I see from other posts that you can format a dimension in a Pivot Table to make it bold using <B>.

I was wondering if anyone knew how to change the text format to '#,##0.00' or '£#,##0.00' etc.

Help much appreciated.

Mike

Text Format a dimension in a Pivot Table

Miguel_Angel_Baeyens — Mon, 23 Aug 2010 13:09:02 GMT

Hello Mike,

If you are talking about dimensions, you need to format them on the Dimensions tab or in the load statement.

But I'm guessing you are talking about expressions, then you can check your expressions format in the "Number" tab in the chart properties, selecting, for example, "Money" which will display currency and two decimals.

Hope that helps

Text Format a dimension in a Pivot Table

Mon, 23 Aug 2010 13:18:07 GMT

Hi,

I am asking about formatting under 'Text Format' tab in Used Dimensions.

My question is what expression would I enter to format the values. E.g. I would enter ='<B>' to make the data bold but I am after an expression to make the format pattern "Money" £#,##0.00 as you would for an expression under number.

Thanks

Mike

Text Format a dimension in a Pivot Table

Mon, 23 Aug 2010 13:58:04 GMT

hi,
edit the dimension...try with the expression.... num(dimension name, '£#,##0.00')

🙂

Text Format a dimension in a Pivot Table

Miguel_Angel_Baeyens — Mon, 23 Aug 2010 13:58:08 GMT

Hello Mike,

As far as I know, the only valid values for "Text Format" are B, K, S, U, even as a result of an expression. That's actually why the Number tab exists. Note that you can change the format pattern in the properties, so, for example, you might use two different currency signs for two different expressions.

So you may use Fabio's suggestion, adding a calculated dimension or create a new field already formatted for your values to be displayed properly in the chart.

Regards.

Text Format a dimension in a Pivot Table

Wed, 25 Aug 2010 10:24:06 GMT

Thanks both - really useful. I have used the following line in my dimension.

=money(TariffCharged,'£#,##0', '.' , ',' )

Mike