This content has been marked as final. Show 3 replies
Hope someone is able to help me with this issue.
I have a table containing the below data:
|303768||0-132-003900000||237015||2018-04-10 16:08:00.000||2018-05-31 16:12:42.567|
|303768||0-132-003900000||246110||2018-04-10 16:08:00.000||2018-08-28 13:17:09.173|
|303768||0-132-003900000||250246||2018-04-10 16:08:00.000||2018-05-31 16:12:42.567|
I need to create a table in Qlik counting numbers of units out but using the MAX(OutDate). So the table in Qlik will show as the following:
As the ID is the same I only need to count this as one unit out.
Thanks in advance.