topic Re: round off in QlikView

round off

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

Hi all,

I am still facing the issue with the format.

I have written this in script

num(floor( duration)/3600,'##.##') as mytime,

duration in seconds.

but I need to show with two decimal

am getting output like below I need 1274.62 like that

1274.621667

1012.946389

Re: round off

Anil_Babu_Samineni — Fri, 04 Aug 2017 10:54:48 GMT

May be this?

=Num(floor( duration)/3600,'#,##0.00')

Re: round off

soniasweety — Fri, 04 Aug 2017 11:07:59 GMT

in list box it is giving the result but when I export it is giving the same result.

so I tried

round( duration/3600) as new

it is giving whole number

like 1274 but I want to add the two decimals to this how to include that?

required: 1274.62

Re: round off

Anil_Babu_Samineni — Fri, 04 Aug 2017 11:09:26 GMT

You could remove Round() to get it

Re: round off

soniasweety — Fri, 04 Aug 2017 11:20:15 GMT

got it anil

I tried below

round(duration/3600,0.01) as new ----------got the correct result.

but same issue for this below expression am unable to get the same

how can I do for this?

Interval(Now()-cmDate,'hh') as lefttime,

cmdate format is :2017-06-30 03:04:46

Re: round off

PrashantSangle — Fri, 04 Aug 2017 11:23:56 GMT

Hi,

Try

round( duration/3600,0.01)

for more details check in help menu. You can do same using Floor() also.

Regards,

Re: round off

sunny_talwar — Fri, 04 Aug 2017 11:26:57 GMT

Same issue with Interval() function? You are seeing extra decimals on export?

Re: round off

soniasweety — Fri, 04 Aug 2017 11:27:55 GMT

yes sunny, still decimals

Interval(Now()-cmDate,'hh') as lefttime, how to do for this?

Re: round off

sunny_talwar — Fri, 04 Aug 2017 11:27:58 GMT

May be try this

Interval(Floor(Now() - cmDate), 1/24), 'hh') as lefttime

Re: round off

Anil_Babu_Samineni — Fri, 04 Aug 2017 11:29:54 GMT

Or this?

Now() returns the Meridian also. So, You have to change it to same format where you are using subtract something like below

Interval(Date(Date#(Now(),'MM/DD/YYYY hh:mm:ss TT'),'YYYY-MM-DD hh:mm:ss')-cmDate,'hh') as lefttime,

Re: round off

soniasweety — Fri, 04 Aug 2017 11:30:04 GMT

syntax error it showing

Re: round off

soniasweety — Fri, 04 Aug 2017 11:33:05 GMT

still same no luck

Re: round off

sunny_talwar — Fri, 04 Aug 2017 11:37:40 GMT

My bad, try this

Interval(Floor(Now() - cmDate, 1/24), 'hh') as lefttime

Re: round off

Anil_Babu_Samineni — Fri, 04 Aug 2017 11:39:27 GMT

I am getting 854? Not correct

Re: round off

PrashantSangle — Fri, 04 Aug 2017 11:57:34 GMT

Hi,

Simple num#() will do the trick.

num#(Interval(Now()-cmDate,'hh'),'#')

Regards,

Prashant

Re: round off

soniasweety — Fri, 04 Aug 2017 12:40:28 GMT

no luck sunny still same

Re: round off

sunny_talwar — Fri, 04 Aug 2017 12:52:33 GMT

Can you share screenshots?

Re: round off

Kushal_Chawda — Fri, 04 Aug 2017 12:56:56 GMT

try this

round(mod(floor((Now()-cmDate)*24*60*60),86400) /3600,0.01)

Re: round off

soniasweety — Fri, 04 Aug 2017 13:13:04 GMT

its not working

1274.62 instead of this giving 1.02 like that all values

Re: round off

Kushal_Chawda — Fri, 04 Aug 2017 13:23:40 GMT

Can you give me one example? above logic will calculate total hours only between two dates