topic Re: Convert seconds into numeric value in QlikView

Convert seconds into numeric value

Mon, 29 Aug 2016 11:41:14 GMT

Hello All,

I have a expression which returns the 119 seconds:

Interval((Sum(TOTAL{<FirstAgent={'<>0'}>}conv)/Count(TOTAL{<FirstAgent={'<>0'}>}ID)/Count(DISTINCT(Date))) +(Sum(TOTAL{<FirstAgent={'<>0'}>} wrap)/Count(TOTAL{<FirstAgent={'<>0'}>}ID)/Count(DISTINCT(Date))),'ss')

Now I have to convert that 119 secs into 119 as a number so that I can continue my formula.

Any idea how I can do it.

Thanks,

Hasvine

Re: Convert seconds into numeric value

MindaugasBacius — Mon, 29 Aug 2016 11:45:37 GMT

Divide all the expression by:

(24*60*60)

Re: Convert seconds into numeric value

avinashelite — Mon, 29 Aug 2016 11:47:23 GMT

Try like this

NUM(

)

Re: Convert seconds into numeric value

Mon, 29 Aug 2016 11:56:59 GMT

Hi Avinash & Mindaugas,

Unfortunately, I do not get the right answer.

Thanks,

Hasvine

Re: Convert seconds into numeric value

tresB — Mon, 29 Aug 2016 12:01:25 GMT

Multiply your expression by: (24*60*60)

Re: Convert seconds into numeric value

avinashelite — Mon, 29 Aug 2016 12:04:23 GMT

You need it in the NUM format or what is the output your excepting ?? could you please explain us the same with an example ? so that it will help us to understand

Re: Convert seconds into numeric value

Mon, 29 Aug 2016 12:07:18 GMT

Thanks Amit.

It works.

KR,

Hasvine