Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Convert seconds into numeric value

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Convert seconds into numeric value

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

6 Replies
MindaugasBacius
Valued Contributor II

Re: Convert seconds into numeric value

Divide all the expression by:

(24*60*60)

Re: Convert seconds into numeric value

Try like this

NUM(

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')

)

Not applicable

Re: Convert seconds into numeric value

Hi Avinash & Mindaugas,

Unfortunately, I do not get the right answer.

Thanks,

Hasvine

MVP
MVP

Re: Convert seconds into numeric value

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

Re: Convert seconds into numeric value

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

Not applicable

Re: Convert seconds into numeric value

Thanks Amit.

It works.

KR,

Hasvine