topic Re: Excel Number not showing correctly in QlikView

Excel Number not showing correctly

Fri, 24 Apr 2015 19:21:52 GMT

I have a chart that has a number that looks like $.18.95

When I send it to Excel the number looks like $18.95

When I put my mouse over the number it changes to 18.9456

I want it to display as only two decimals not four. Can this be done.

David

Re: Excel Number not showing correctly

robert_mika — Fri, 24 Apr 2015 19:37:02 GMT

Try

=Num(18.9456,'##.00')

Re: Excel Number not showing correctly

sunny_talwar — Fri, 24 Apr 2015 19:38:15 GMT

Are you using Numbers tab from chart properties to define the number format or are u defining the number format within your expression itself using Num() function?

Re: Excel Number not showing correctly

Sat, 25 Apr 2015 00:16:07 GMT

I have tried both and cant get either to work. The field is called trnstotalcost. In the expression I tried:

=num(sum(trnstotalcost),'$##.00')

Any suggestions as to which one is better.

David

Re: Excel Number not showing correctly

sunny_talwar — Sat, 25 Apr 2015 01:15:39 GMT

I think for the export to work, you need to do it in the export tab. Num() does it only for the QlikView viewing, as soon as you export the format will go away.

HTH

Best,

Sunny

Re: Excel Number not showing correctly

PrashantSangle — Sat, 25 Apr 2015 05:33:47 GMT

Hi,

For that you can use round()

round(sum(trnstotalcost),0.01)

Regards

Re: Excel Number not showing correctly

Anonymous — Sat, 25 Apr 2015 16:19:55 GMT

Hi!

you can try to set in the way you prefer these variables in the script editor:

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='$ #.##0,00;-$ #.##0,00';

KR,

Elena

Re: Excel Number not showing correctly

Gabriel — Sat, 25 Apr 2015 21:51:49 GMT

Hi,

This is interesting, can you post sample file?