topic Re: Start time and end time in a time frame of 15 minutes interval in QlikView

Start time and end time in a time frame of 15 minutes interval

safik003 — Sat, 16 Nov 2024 03:34:30 GMT

Hi All,

I'm stuck at a point. There are Start_Time and End_Time fields of a table. I need to adjust them in a 15 minutes interval time frame in a pivot table....How can I achieve this using class function or IntervalMatch funtion? Thanks in advance.

For example...if the Start_Time is 03:46 and End_Time is 04:17...I need to map them in a 15 minutes time frame like below along with the time difference.

03.30 - 03.45

03.45 - 04.00

04.00 - 04.15

04.15 - 04.30 and so on...

Re: Start time and end time in a time frame of 15 minutes interval

sunny_talwar — Wed, 15 May 2019 11:33:16 GMT

So, you raw data gives Start_Time of 03:46 and End_Time of 04:17 and you want to break it out into 4 buckets? Is this you want to do in the script or directly in the pivot table? Also, is this a dimension or an expression?

I am not sure if this is possible to do directly in the pivot table, but a script solution might be possible.

Re: Start time and end time in a time frame of 15 minutes interval

safik003 — Wed, 15 May 2019 12:59:38 GMT

Sample table The table looks like this.

Start_Time and End_Time are dimensions which are directly coming from database. How can I achieve his? Mapping of timeframe and Start_Time and End_Time? Hope I'm able to make you understand.

Re: Start time and end time in a time frame of 15 minutes interval

Brett_Bleess — Tue, 25 Jun 2019 20:49:58 GMT

Not sure if this is going to help or not, but providing two links below, basic IntervalMatch and extended IntervalMatch, hopefully one of them will help you move things forward here.

Basic: https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/IntervalMatch.htm

Extended: https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/IntervalMatch_(Extended_Syntax).htm

Regards,
Brett