topic number setting in properties? in QlikView

number setting in properties?

Anonymous — Tue, 26 Aug 2014 20:01:55 GMT

Hi I want to change my number format from like let's say $95,800,000 to $95.8 (in millions) in a pivot table. Is there a way i could do it in the settings?

Thanks!

Re: number setting in properties?

Tue, 26 Aug 2014 20:11:25 GMT

Divide your expression by 1,000,000

Then in the numbers tab, have it show only one decimal

Re: number setting in properties?

JonnyPoole — Tue, 26 Aug 2014 20:12:15 GMT

change the format to 'money' and type this in to the format pattern:

$#,##0.0M;($#,##0.0M)

... you will have to also divide your existing expression on the expression tab by 1000000 (1 million).

(But this isn't done exclusively on the number tab so not sure if you are looking for something better)

Re: number setting in properties?

Anonymous — Tue, 26 Aug 2014 20:19:30 GMT

Thank you... Would it be possible to just do it on the settings without dividing by 1MM on the expression tab?

Thanks,

Re: number setting in properties?

JonnyPoole — Tue, 26 Aug 2014 20:32:38 GMT

well this is a million symbol property on the number tab in the lower right.

funny thing is if you toggle the chart type and go back , the properties are sometimes enabled.

but when you enter a value like 'M' , hit ok the changes aren't applied and the properties become greyed out.

So... i'm not 100% sure and i suspect some buggy behaviour because of a recent post to the same effect:

Million Symbol in Chart

If its important i would suggest logging a support issue with qlik . it could be a bug. or just use the workaround of '/1000000' on the expression definition.

Re: number setting in properties?

Anonymous — Tue, 26 Aug 2014 20:37:34 GMT

Yea exactly.. I thought it didn't apply to pivot table. Anyways, thanks for your help!