topic Round Function Display in QlikView

Round Function Display

Wed, 01 Sep 2010 20:17:56 GMT

I am using the round function. Is there a way to force the result to display the position to the right of the decimal even when it is zero? For example with this code

Round(Sum (SLA_MTH_TON_00005),.1)

When SLA_MTH_TON_00005 equals 19.0 it displays as 19. I want it to keep the format with one place to the right of the decimal for consistency sake as most of the numbers do not come out to an even whole number.

Round Function Display

Wed, 01 Sep 2010 20:24:44 GMT

i never use this funcion

but did you try

Round(Sum (SLA_MTH_TON_00005), 0.1)

or depends object you are using.....you can format on properties!!!!

Round Function Display

Wed, 01 Sep 2010 20:26:15 GMT

Sorry.....my answer is wrong....i think you can use a

NUM(your expression, '#,##0.0')

Round Function Display

montubhardwaj — Wed, 01 Sep 2010 20:48:12 GMT

you can go to the properties-->Number format and then choose "Fixed to" 1 decimal place.

Hope that was helpful.

Cheers,

Sharma

Round Function Display

Wed, 01 Sep 2010 20:53:21 GMT

That does not seem to work. I still get 19 instead of 19.0. The Round function seems to be overriding the format.

Round Function Display

Wed, 01 Sep 2010 20:56:38 GMT

did you try this????

NUM((Sum (SLA_MTH_TON_00005),.1), '#,##0.0')

because NUM function with this format force .0!!!!!

Round Function Display

Wed, 01 Sep 2010 20:57:37 GMT

Sharma,

I can't change it on the number tab because it's not always one decimal. It can vary according to other criteria. When the criteria is for one decimal I want to show that way though.

Round Function Display

Wed, 01 Sep 2010 21:02:56 GMT

Erico,

Yes I tried that. It's a large expression but here is my exact code. The very last part is where I tried the num function.

IF ((SLA_RECORD_SORT = '0001' OR SLA_RECORD_SORT = '0002' OR SLA_RECORD_SORT = '0003' OR SLA_RECORD_SORT = '0004') AND (SLA_LINE='196' OR SLA_LINE='197' OR SLA_LINE='199' OR SLA_LINE='200' OR SLA_LINE='201' OR SLA_LINE='203' OR SLA_LINE='205'OR SLA_LINE='209' OR SLA_LINE='230') ,Round(Sum (SLA_MTH_TON_00004)),num (ROUND (Sum (SLA_MTH_TON_00004),0.1),'#,##0.0'))

Round Function Display

Wed, 01 Sep 2010 21:05:27 GMT

But you have a two expression with Round.....and you put just in one....

Did you see at the other post from you.....i sugest change your "large" expression to another with set analisys???

Round Function Display

Wed, 01 Sep 2010 21:11:06 GMT

Try this

NUM(ROUND(Sum ( {$<SLA_RECORD_SORT={'0001','0002','0003','0004'},SLA_LINE={'196','197','199','200','201','203','205','209','230'}>} SLA_MTH_TON_00004),.1),'#,##0.0')

Round Function Display

Wed, 01 Sep 2010 21:18:12 GMT

I have two"rounds" becuase if the expression is true it does the first "round" which leaves the answer as a whole number for lines 196,197. ect. If the expression is not true it rounds it to one decimal place. The format of the answer varies according to the line.

Round Function Display

Wed, 01 Sep 2010 21:20:04 GMT

Can you put your QVW file???....i try to help you.....

I just need you put on zip format!!!!!

Round Function Display

Miguel_Angel_Baeyens — Wed, 01 Sep 2010 21:20:37 GMT

Hello Jim,

You may try

Num(Sum(SLA_MTH_TON_00005), '#,##0.0')

which force the number to show one decimal number, even when the result is integer. There's no need for Round() as your problem doesn't seem to be the rounding of decimal positions, but the way you want them displayed.

Besides, your complete expression (my untested suggestion) may be

IF(MATCH(SLA_RECORD_SORT, '0001', '0002', '0003', '0004') > 0 AND MATCH(SLA_LINE, 196, 197, 199, 200, 201, 203, 205, 209, 230) > 0, Num(Sum(SLA_MTH_TON_00004), '#,##0.0'), Num(Sum(SLA_MTH_TON_00004), '#,##0.0'))

Make sure that you are using "," as thousands separator and "." as decimal separator.

Note that some parentheses or brackets may not be properly closed.

Hope that helps.