topic Re: Tbale chart format issue in QlikView

Tbale chart format issue

alec1982 — Mon, 05 Nov 2012 15:34:00 GMT

hi Guys,

I have a table chart where the nrs on it are showing like:

Total Sales ######

Total Trans ######

Profit $154,785

the nrs that showing in ###### are large nrs like 62,514,478

Anybody knows how to fix that?

Thxs for your help.

Badr

MayilVahanan — Mon, 05 Nov 2012 15:37:32 GMT

Try like this

=Num(sum(Sales),'###0')

and drag the column by mouse for enlarge it..

Hope it helps

alec1982 — Mon, 05 Nov 2012 15:39:45 GMT

Hi,

Thank you for your help. That's what i tried before but it didn't help.

Thxs,

Alec

MayilVahanan — Mon, 05 Nov 2012 15:45:16 GMT

Can you post a sample file?

or try in number tab-> integer ,in format pattern gives number of # as per your requirement to display the number

Mon, 05 Nov 2012 15:47:13 GMT

Properties->Numbers->Select the fields to Money

Best regards,

TMF