Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

jcfrasco
Contributor

How do I format the number format of a dimension (not expression)?

Hi

This is a really simple question that I'm hoping has a really simple answer. Any help would be greatly appreciated.

I'm plotting a histogram of returns using Floor(Return,0.01) as my dimension and Count(Return) as my expression. It works perfectly, but I would like the x-axis formatted as %. I can't find anywhere to do this.

Thanks.

Joao.

1 Solution

Accepted Solutions
giakoum
Honored Contributor II

Re: How do I format the number format of a dimension (not expression)?

num(Floor(Return,0.01), '# ##0.00%')

maybe this helps

5 Replies
srikanthsri1
Valued Contributor

Re: How do I format the number format of a dimension (not expression)?

in number select percentage

giakoum
Honored Contributor II

Re: How do I format the number format of a dimension (not expression)?

num(Floor(Return,0.01), '# ##0.00%')

maybe this helps

jcfrasco
Contributor

Re: How do I format the number format of a dimension (not expression)?

The dimension does not appear in Number.

Joao

Sent from my iPad

Not applicable

Re: How do I format the number format of a dimension (not expression)?

editdimension.png

Go to Chart properties --> Dimensions --> Add 'Return' as Dimension and then Edit to make it

=num(Floor(Return,0.01),'###0.00%')

Regards

Raj

jcfrasco
Contributor

Re: How do I format the number format of a dimension (not expression)?

This is exactly what I needed.

Thank you.

Kind regards,

Joao Frasco

Chief Investment Officer

T +27 11 448 6983

F +27 11 448 6526

C +27 71 887 7698

W www.stanlib.com<http://www.stanlib.com/>

17 Melrose Boulevard

Melrose Arch, 2196

Johannesburg, South Africa

PO Box 202

Melrose Arch, 2076

Johannesburg, South Africa

Community Browser