topic How to round up the values in the expression ? in QlikView

How to round up the values in the expression ?

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

Hello,

I have Net_Risk_Position as a dimension in my table with values as shown below;

Net Risk Position
(R)44000
(R)91255.394516
(C)-79240
(R)4587.658936
(R)19875

How to write an expression to round up the values to 2 decimals as shown below;

Net Risk Position
(R)44000.00
(R)91255.39
(C)-79240.00
(R)4587.66
(R)19875.00

thanks

Bhavesh

Re: How to round up the values in the expression ?

settu_periasamy — Fri, 05 Oct 2018 20:48:21 GMT

Try this

LOAD Left([Net Risk Position],3)&Num(SubField([Net Risk Position],')',-1),'###.00') as [Net Risk Position];
LOAD * INLINE [
Net Risk Position
(R)44000
(R)91255.394516
(C)-79240
(R)4587.658936
(R)19875
];

Re: How to round up the values in the expression ?

vishsaggi — Fri, 05 Oct 2018 21:00:57 GMT

Another way using Mid() function can be like

Left([Net Risk Position],3)&Num(Mid([Net Risk Position], Index([Net Risk Position],')')+1,Len([Net Risk Position])), '###0.00') AS NetPost

Re: How to round up the values in the expression ?

bhaveshp90 — Fri, 05 Oct 2018 21:10:33 GMT

Perfect, that worked out for me. thank you

Re: How to round up the values in the expression ?

bhaveshp90 — Fri, 05 Oct 2018 21:11:13 GMT

thank you for your response, but I have 2 million records to convert.