topic Expression for Quantity without decimals in Listbox in QlikView

Expression for Quantity without decimals in Listbox

Anonymous — Thu, 10 May 2012 10:03:37 GMT

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??

Re: Expression for Quantity without decimals in Listbox

sivarajs — Thu, 10 May 2012 10:24:26 GMT

use

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

Re: Expression for Quantity without decimals in Listbox

IAMDV — Thu, 10 May 2012 10:25:48 GMT

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

Expression for Quantity without decimals in Listbox

Anonymous — Thu, 10 May 2012 10:35:03 GMT

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', '.' , ',' )

Expression for Quantity without decimals in Listbox

Anonymous — Thu, 10 May 2012 10:39:33 GMT

Hi Leni

thanks, but also not working out.

showing null values and changed the number format to:

220,##0

Expression for Quantity without decimals in Listbox

Anonymous — Thu, 10 May 2012 10:43:09 GMT

Hi,

Just try this

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

Re: Expression for Quantity without decimals in Listbox

IAMDV — Thu, 10 May 2012 10:44:45 GMT

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

Thanks - DV

Re: Expression for Quantity without decimals in Listbox

Anonymous — Thu, 10 May 2012 10:46:26 GMT

for

ceil()

floor()

round()

=Num(Quantity,'##0')

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

any ideas??

Re: Expression for Quantity without decimals in Listbox

sivarajs — Thu, 10 May 2012 11:05:56 GMT

check your 3rd listbox in the attached file

Expression for Quantity without decimals in Listbox

Anonymous — Thu, 10 May 2012 11:07:54 GMT

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