Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excel Number not showing correctly

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

1 Solution

Accepted Solutions
PrashantSangle

Hi,

For that you can use round()

round(sum(trnstotalcost),0.01)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

7 Replies
robert_mika
Master III
Master III

Try

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

sunny_talwar

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?

Not applicable
Author

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

sunny_talwar

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

PrashantSangle

Hi,

For that you can use round()

round(sum(trnstotalcost),0.01)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Anonymous
Not applicable
Author

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

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

This is interesting, can you post sample file?