topic Re: Prob regarding Script in QlikView

Prob regarding Script

nikhilgarg — Thu, 26 Feb 2015 11:29:39 GMT

Hey,

I want to see the session length which is a column in session log file. I used following statement but it gives me no value under the column.

Num(Interval#(SessionDuration, 'hh:mm:ss')*24, '#,##0') as SessionLength

Also can anyone tell me what is this interval#() return if my Session Duration is : 13:21:45

Also why we need to multiply by 24?(Script is already created , not created by me so i have no idea why 24 is used)

Thanks

Re: Prob regarding Script

Gysbert_Wassenaar — Thu, 26 Feb 2015 11:50:24 GMT

I don't think multiplying by 24 is necessary as long as you understand that the value that the interval# function returns has days as unit. So 13:21:45 would become 0.556770833333, i.e. a bit more than half a day.

Re: Prob regarding Script

nikhilgarg — Thu, 26 Feb 2015 11:53:20 GMT

Ohk so you mean interval#() returns the duration in comparison with day i.e whether half day or more or less.

Re: Prob regarding Script

Anonymous — Thu, 26 Feb 2015 11:57:28 GMT

Hi Nikhil,

From Help:

Interval#

interval#(expression [ , format-code ])

The interval# function evaluates the expression as a time interval according to the string given as a format-code. If the format code is omitted, the time format set in the operating system is used.

The interval# function generally behaves just like the time# function but while times can never be greater than 23:59:59 (numeric value 0.99999) or smaller than 00:00:00 (numeric value 0.00000) an interval may have any value.

Examples:

The examples below assume the following operating system settings:

Short date format:	YY-MM-DD
Time format:	hh:mm:ss
Number decimal separator:	.

interval#( A, 'D hh:mm' ) where A=1 09:00 returns:


String	1 09:00
Number	1.375

interval#( A-B ) where A=97-08-06 09:00:00 and B=97-08-05 00:00:00 returns:


String	1.375
Number	1.375

Regards

Neetha

Re: Prob regarding Script

nikhilgarg — Thu, 26 Feb 2015 12:05:08 GMT

Hey,

Yeah i ahve gone thru that but was not clear about it initially. But now i am clear almost. it works in multiples of base, ryt?? And also does offset decreases the offset value from resultant value??

Re: Prob regarding Script

jonathandienst — Thu, 26 Feb 2015 12:37:10 GMT

Multiplying by 24 will convert the value to hours

Re: Prob regarding Script

Gysbert_Wassenaar — Thu, 26 Feb 2015 13:12:56 GMT

That I know. I just think that it's unnecessary.

Re: Prob regarding Script

nikhilgarg — Thu, 26 Feb 2015 13:25:57 GMT

Thanks dienst

Re: Prob regarding Script

Anonymous — Thu, 26 Feb 2015 14:09:46 GMT

Yes,it works in multiples of base,Multiplying by 24 will Show output in hours.

'And also does offset decreases the offset value from resultant value??' - there is no offset parameter in expression:

interval#(expression [ , format-code ])

Regards

Neetha

Re: Prob regarding Script

nikhilgarg — Thu, 26 Feb 2015 14:12:30 GMT

Yeh, Actually mistakenly i paste this in this section instead of Floor question post