topic Re: number format in QlikView

number format

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

any solution to change the number format on a text object?

if(Month= 'Jan', sum({$<Years= {'2016'},material= {'0335'},[budget] = {'T'},Type={'OK'}>} Values)

+ sum({$<Month = {'Feb','Mar'},material= {'0335'},[budget] = {'TA'},Type={'NO'}>} Values))

I need it in this format -- € #.##0,00;€ -#.##0,00

MK_QSL — Thu, 07 Jul 2016 08:35:02 GMT

Money(

if(Month= 'Jan', sum({$<Years= {'2016'},material= {'0335'},[budget] = {'T'},Type={'OK'}>} Values)

+ sum({$<Month = {'Feb','Mar'},material= {'0335'},[budget] = {'TA'},Type={'NO'}>} Values))

,-- € #.##0,00;€ -#.##0,00)

sushil353 — Thu, 07 Jul 2016 08:43:37 GMT

Try this:

num(

if(Month= 'Jan', sum({$<Years= {'2016'},material= {'0335'},[budget] = {'T'},Type={'OK'}>} Values)

+ sum({$<Month = {'Feb','Mar'},material= {'0335'},[budget] = {'TA'},Type={'NO'}>} Values)),

'€ #.##0,00')

HTH

boorgura — Thu, 07 Jul 2016 15:12:21 GMT

num(

if(Month= 'Jan', sum({$<Years= {'2016'},material= {'0335'},[budget] = {'T'},Type={'OK'}>} Values)

+ sum({$<Month = {'Feb','Mar'},material= {'0335'},[budget] = {'TA'},Type={'NO'}>} Values)),

'€ #.##0,00;€ -#.##0,00')