Discussion Board for collaboration related to QlikView App Development.
I have problem to create min and max timestamp. My rawdata looks like this.
expected below, I can not use a min and max and do a Group by on Dimension because all dimension will be repeated.
This has to be done in the load script.
|44-150||2017-08-25 11:00:00||2017-08-25 11:01:59|
|50-100||2017-08-25 11:02:59||2017-08-25 11:05:59|
|63-125||2017-08-25 11:06:59||2017-08-25 11:08:59|
|50-100||2017-08-25 11:09:59||2017-08-25 11:10:59|
as I said, this will not work, for ex this will give me one row on 50-100 With MinTime 2017-08-25 11:02:59 and MaxTime 2017-08-25 11:10:59 that is not correct.
YES, this will create a Group of all Dimension and add a Field that can be used as a keyfield, thanks.
I will test this in my script and comes back to you.