topic Re: Convert Date time into Seconds in Qlikview. in QlikView

Convert Date time into Seconds in Qlikview.

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

Hi,

Can any one please suggest me how to convert [ Date Time] into Seconds while loading the script:

Ex: I have a column with Generate time and start time and than Elapsed time as time interval between start and generate, I want to split the rows with Elapsed time (30 secs) into 30 different rows with row one as 1 sec and row 2 as 2 secs and 3 as 3 secs and so on (This is for Analysis purpose) .

If any one can suggest how to convert the date time into complete seconds, so that I can use iterno() function to loop through and generate the records.

Thanks and Regards

Re: Convert Date time into Seconds in Qlikview.

Anil_Babu_Samineni — Mon, 25 Sep 2017 13:58:30 GMT

May be this?

Load Interval(Start, 'ss') + IterNo() - 1 as Start

While Interval(Seconds, 'ss') + IterNo() - 1 <= Interval(Generate, 'ss')

Re: Convert Date time into Seconds in Qlikview.

Anonymous — Mon, 25 Sep 2017 14:31:47 GMT

Hi Anil, the scenario is like this:

starttime= 25/09/2017 15:10:20

Endtime= 25/09/2017 15:11:09

Elapsed time = 63 seconds ( endtime-starttime)

Now I want to generate a column which splits the elapsed time into 1 to 63 seconds ( 63 rows expected) and with a session id Unique key of course. so the new row should split the elapsed time into 1,2,3....63 seconds , I expecting a looping function to do this .......

Regards

Re: Convert Date time into Seconds in Qlikview.

Anonymous — Mon, 25 Sep 2017 14:46:54 GMT

Hi Anil ,

Or the best way is to convert 25:09:2017 15:10:20 completely into Seconds and then loop through the initial values till th..Ifff

Re: Convert Date time into Seconds in Qlikview.

sunny_talwar — Mon, 25 Sep 2017 15:27:27 GMT

While is a looping function in the script... check this out

Loops in the Script

Re: Convert Date time into Seconds in Qlikview.

Anonymous — Mon, 25 Sep 2017 15:54:47 GMT

Hi Sunny, its looping but with a complication:

I have 25:09:2017 15:20:30 as start date and

I have 25:09:2017 15:24:45 as End date

Elapsed time is end date-start date 63 secs for example.

I am looking for an extra column which reads elapsed time in descending order until it reaches 63 (which means 63 rows for one Session id......

I Hope its helpful

Regards

Re: Convert Date time into Seconds in Qlikview.

Anil_Babu_Samineni — Mon, 25 Sep 2017 16:46:44 GMT

PFA

Re: Convert Date time into Seconds in Qlikview.

Anonymous — Mon, 02 Oct 2017 15:41:42 GMT

Thanks Anil

Re: Convert Date time into Seconds in Qlikview.

Anonymous — Mon, 02 Oct 2017 15:42:04 GMT

Thanks Sunny

Re: Convert Date time into Seconds in Qlikview.

Anil_Babu_Samineni — Wed, 11 Oct 2017 09:36:44 GMT

Your issue resolved? So, Please mark it as correct answer and make some helpful answers in this thread if respect to issue