Can you change format of dimensions in qlikview?

[#1]

In Qlikview, when you create a chart you have dimensions and expressions. You can change the format of the expressions in QV as well in case of table you can change the format of each of the fields but how do you change the format of dimensions?

[ashfaq_haseeb]

Hi,

You can use calculated dimension feature.

Regards

ASHFAQ

[nilo_pontes]

Hi Ronak,

You can either change the formats on number's tab or by creating your own formated formula in dimensions tab.

Hope it helps you.

Regards,

Nilo

[rwunderlich · Accepted solution]

You can change the Document default for a given field in Document Properties, Number pane.

To change the format of a dimension in an individual chart, you need to use a calculated dimension that contains the formatting function. For example:

=date(OrderDate,'DD/MM/YYYY')

-Rob