Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

psumunod
New Contributor

How to iterate contents of table from another table?

Is this possible to do in Qlikview?

This is the original table loaded from database.

   

VariableStatusDateDuration
AStatusA9/10/2017 18:30:00.004
AStatusB9/10/2017 23:30:00.005
BStatusA9/10/2017 10:00:00.008
BStatusB9/10/2017 21:45:00.009

And how I want this to process.

    

VariableStatusDateDurationEndDate
AStatusA9/10/2017 18:30:00.0049/10/2017 22:30:00.00
AStatusB9/10/2017 23:30:00.000.59/10/2017 23:59:59.59
AStatusB9/11/2017 0:00:00.004.59/11/2017 3:30:00.00
BStatusA9/10/2017 10:00:00.0089/10/2017 18:00:00.00
BStatusB9/10/2017 21:45:00.002.259/10/2017 23:59:59.59
BStatusB9/11/2017 0:00:00.006.759/11/2017 6:15:00.00

I know this is possible through resident table but how to check if the variable's running time exceeded a day then creates another row to separate the duration to next day. This is the case because I have a filter by week so if the last day (or Saturday) has a variable with exceeded duration, data won't be accurate.

The result data will need to get the total duration per variable which is filtered by week.