topic Re: Create Column in Script in QlikView

Create Column in Script

ankur_abhishek — Wed, 05 Jul 2017 06:33:55 GMT

Hi ,

I want to create the below Time column at script level instead of a pivot table in UI.

I have use this formula to calculate Time (:

If(Dimensionality() > 2,

Interval(

If(RowNo()=1,0,If(RangeSum(page_viewed_datetime,-Above(page_viewed_datetime))> 0,

RangeSum(page_viewed_datetime,-PTime))),'mm'),

Interval (Max({<page_viewed={'Logout Page'}>} page_viewed_datetime)-

Min({<page_viewed={'Login Page'}>} page_viewed_datetime),'mm')

)

It calculating the time an user stay on a Page

Kindly help me in creating calculated column (Time) .

ahaahaaha — Wed, 05 Jul 2017 07:33:51 GMT

Hi,

May be like this for [Time] field

Time(Timestamp#(page_viewed_datetime, 'MM/DD/YYYY hh:mm'))

Regards,

Andrey

ankur_abhishek — Wed, 05 Jul 2017 07:58:30 GMT

HI Andrey ,

My requirement is different i want to know how much time user stay (browser) the page. for that i have used expression as mentioned above.

Can you help me in creating a column in script.

Thanks

Ankur

antoniotiman — Wed, 05 Jul 2017 08:19:51 GMT

Hi Ankur,

See Attachment.

Field is PTime1.

Regards,

Antonio

ahaahaaha — Wed, 05 Jul 2017 08:35:07 GMT

May be like at attached file

ankur_abhishek — Wed, 05 Jul 2017 09:12:20 GMT

Thanks Antonio