topic Re: round seconds in QlikView

round seconds

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

Hi all ,

I have one column like duration

that are in seconds like

30210.00

916372.00

56483.00

like above I don't want to see .00 I want output like

hh.mm : =30210 is to be shown like this 8.39

am using in my script already like this Num([Duration],'#.#0') as "Task Duration", I need along with this format

Thanks

Sony

PrashantSangle — Thu, 13 Jul 2017 12:36:45 GMT

try like

floor(fieldName)/3600

Regards

soniasweety — Thu, 13 Jul 2017 12:38:58 GMT

thanks Prashanth,

but I need the format also like what I mentioned above.

how can include this into above?

is this correct?

floor( Num([Duration]/3600,'#.#0')) as "Task Duration"

PrashantSangle — Thu, 13 Jul 2017 12:41:09 GMT

num(floor(dateField)/3600,'##.##')

Regards

soniasweety — Thu, 13 Jul 2017 12:45:58 GMT

thanks prashanth its working as expected