topic Re: Number Format in QlikView

Number Format

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

Hi Guys,

this is what i have in my app.

I would like to have just thousand , for example 9.532, i would like to see only 10 (rounded)

for 45.735 i would like to see 46

for 19.106 i would like to see 19

I tried to change the format pattern, but i didnt get the result expected.

Any advice how to setup the format pattern?

Thank you!

Re: Number Format

vinieme12 — Wed, 21 Jun 2017 09:52:14 GMT

Use Round()

example =Round(Field)

Round ‒ QlikView

Re: Number Format

qlikviewaf — Wed, 21 Jun 2017 09:54:25 GMT

what about having only the K ? (e.g. for 45.735 i would like to see 46)

Re: Number Format

avinashelite — Wed, 21 Jun 2017 09:56:15 GMT

What you mean by having only the K??

Re: Number Format

prma7799 — Wed, 21 Jun 2017 09:56:29 GMT

You can use Num also

=Num(45.735,'##')

Re: Number Format

qlikviewaf — Wed, 21 Jun 2017 09:58:41 GMT

as you see now i have on the table 45.735 - i would like to see only 45

Re: Number Format

avinashelite — Wed, 21 Jun 2017 10:01:09 GMT

Try like this

Round(Field/expression) this will give the desired result

Re: Number Format

qlikviewaf — Wed, 21 Jun 2017 10:02:42 GMT

in this way i have 46.000 i would like to have only 46, without the 000

Re: Number Format

avinashelite — Wed, 21 Jun 2017 10:04:58 GMT

Did you tries the way we suggested it will give the exact result what your excepting

Re: Number Format

marcus_malinow — Wed, 21 Jun 2017 10:18:12 GMT

Hi,

change your format pattern to remove everything after the decimal point:

$ #;-$ #

Marcus

Re: Number Format

qlikviewaf — Wed, 21 Jun 2017 10:19:50 GMT

Re: Number Format

avinashelite — Wed, 21 Jun 2017 10:22:04 GMT

After applying Round() >Go to chart Properties >number > set the expression to default format that will give the result

Re: Number Format

qlikviewaf — Wed, 21 Jun 2017 10:24:39 GMT

not working, i would like to see only 159 not 159580 (example based on the first row)

Re: Number Format

vinieme12 — Wed, 21 Jun 2017 10:30:17 GMT

Just divide by 1000 then !

=if(vExcludeInstrumentSales,

Sum({<Area-={'Area-not-available'},Year=, Month=, Quarter=, Week=, Day=,Invoice_Date=, Invoice_Date_Num={">=$(=Num(MonthStart(Max(Invoice_Date_Num))))<=$(=Max(Invoice_Date_Num))"}>} ExtendedUSD),

Sum({<Area-={'Area-not-available'},Year=, Month=, Quarter=, Week=, Day=,Invoice_Date=, Item_Category={$(vNoInstruments)}, Invoice_Date_Num={">=$(=Num(MonthStart(Max(Invoice_Date_Num))))<=$(=Max(Invoice_Date_Num))"}>} ExtendedUSD))

/1000

159.580 = 160 i hope that is what you were after since the beginning!

Re: Number Format

marcus_malinow — Wed, 21 Jun 2017 10:37:32 GMT

My bad :

£ #,##0;-£ #,##0

Re: Number Format

BalaBhaskar_Qlik — Wed, 21 Jun 2017 13:34:04 GMT

Re: Number Format

Anonymous — Wed, 21 Jun 2017 14:30:39 GMT

Hello - you can use the box called Thousand Symbol; in your example you would add K instead of "Thous". Qlik will adjust how the number displays without you having to divide by 1000.

Hope this helps,

Kathleen