topic Re: Rounding / Formatting Dollar Amount In Straight Table in QlikView

Rounding / Formatting Dollar Amount In Straight Table

pnn44794 — Wed, 25 Nov 2020 16:16:04 GMT

Hello:

I think I've been looking at this problem too long and trying too many different ways to get what I need done. I'm missing something simple.

I have values in a straight table, fieldname Total Cost, like the following:

Total Cost

2164

-97295

10094

127433

etc

I want the values to be formatted as follows:

Total Cost

$2.2 K

-$97.3 K

$10.1 K

$127.4 K

Any suggestions? As always, I appreciate any and all responses. Thanks in advance.

Re: Rounding / Formatting Dollar Amount In Straight Table

sergio0592 — Mon, 26 Jun 2017 20:58:55 GMT

It works with : money(round(sum([Total cost])/1000,0.1),'$# ##0,0 K')

Re: Rounding / Formatting Dollar Amount In Straight Table

pnn44794 — Mon, 26 Jun 2017 21:08:15 GMT

Thanks for the reply Jean-Baptiste. Total Cost is a field that is not calculated. I pull it in via my load script from a database. Would this work in my load script or do I need to do this via an expression within the dashboard?

Re: Rounding / Formatting Dollar Amount In Straight Table

MarcoWedel — Mon, 26 Jun 2017 22:37:16 GMT

Re: Rounding / Formatting Dollar Amount In Straight Table

pnn44794 — Tue, 27 Jun 2017 15:11:50 GMT

Thanks for your reply Marco. I'm looking at the other question you responded to.