Tbale chart format issue - Qlik Community

alec1982 · ‎2012-11-05

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 · ‎2012-11-05

Hi

Try like this

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

and drag the column by mouse for enlarge it..

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

alec1982 · ‎2012-11-05

Hi,

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

Thxs,

Alec

MayilVahanan · ‎2012-11-05

Hi

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Report Inappropriate Content · ‎2012-11-05

Hi

Properties->Numbers->Select the fields to Money

Best regards,

TMF