Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Visualization and Usability

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now

Who Me Too'd this topic

wanass123
Contributor III
Contributor III

First Pending Orders Snapshot by Day and Time

I have a table show the pending orders multiple times in a day 

like this : 

 

DateTIme Total _Pending
3/11/24 11:00 AM 22
3/11/24 10:00 AM 44
3/11/24 1:00 PM 12
3/12/24 11:00 AM 43
3/12/24 7:00 AM 45
3/12/24 9:00 AM 66

 

I need the Total pending for the first record by day  & time , result : 


DateTIme Total _Pending
3/11/24 10:00 AM 44
3/12/24 7:00 AM 45
Who Me Too'd this topic