Expression for Quantity without decimals in Listbox

[Anonymous]

I want to show quantity in my listboxes without any decimals.

What expression can I use since I can't manually change the number format in listboxes??

[sivarajs]

use

round(field name)  or num(fieldname,'#,###') in listbox expression

[IAMDV]

Hi Chris,

You can change the formatting of the ListBox but the underlying values still hold decimal places.

However, if wanted to exclude the decimal places then you can use Ceil() or Floor() functions as Expression in the ListBox.

Cheers - DV

www.QlikShare.com

[Anonymous]

Sivaraj-

using round() worked for some, but it changed many to Null values

DV-

using ceil() and Floor()

did the same thing as round, and changed many to null values

Is there not an expression like the following for formatting money values??

Money(sum(Sales), 'R#,##0', '.' , ',' )

[Anonymous]

Hi Leni

thanks, but also not working out.

showing null values and changed the number format to:

220,##0

[Anonymous]

Hi,

Just try this

=num(Money(FileName),'#,##0')

[IAMDV]

Chris - Please can you post the sample QV file or some sample data?

Thanks - DV

[Anonymous]

for

ceil()

floor()

round()

=Num(Quantity,'##0')

it only shows values to the hundreds and anything greater is marked as Null

any ideas??

[sivarajs · Accepted solution]

check your 3rd listbox in the attached file

[Anonymous]

Hi,

In your 3rd listbox -> 2nd expr -> give "=sum(quantity)" instead of "sum(quantity)".

When I gave "=" sign in front of tat expr, it didnt show the decimal value

Just give a try