Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
jumiprado
Creator
Creator

Group by timestamp Dates

Guys, hello

I have the following report from access system for the Staff and i need to make a control access application per day where i can sum total_hhmmss for each day and compare the field Total_hhmmss with the difference between date_entrance and date_exit for check if the report works properly.

nametotal_hhmmssdate_entrancedate_exit
STAFF101:12:0002/11/2018 16:2502/11/2018 17:37
STAFF101:51:0005/11/2018 16:1005/11/2018 18:01
STAFF101:19:0006/11/2018 16:0806/11/2018 17:27
STAFF101:49:0007/11/2018 16:0407/11/2018 17:53
STAFF101:57:0008/11/2018 16:0808/11/2018 18:05
STAFF102:09:0012/11/2018 16:0712/11/2018 18:16
STAFF101:20:0013/11/2018 16:2613/11/2018 17:46
STAFF101:56:0015/11/2018 16:1015/11/2018 18:06
STAFF100:21:0016/11/2018 16:0516/11/2018 16:26
STAFF101:22:0020/11/2018 16:0420/11/2018 17:26
STAFF101:29:0021/11/2018 16:1321/11/2018 17:42
STAFF100:12:0021/11/2018 17:4221/11/2018 17:54
STAFF101:23:0022/11/2018 16:0922/11/2018 17:32
STAFF101:58:0026/11/2018 16:0826/11/2018 18:06
STAFF101:24:0003/12/2018 16:2603/12/2018 17:50

 

 

Thanks!

Labels (4)
2 Replies
MindaugasBacius
Partner
Partner

Could you provide the preferred result from your row data?

Thank you

jumiprado
Creator
Creator
Author

I need something like this:

 

namedate_entrancedate_exitDate_Entrance2Date_Exit2total_hhmmssDif Between Timestamp
STAFF102/11/2018 16:2502/11/2018 17:3702/11/201802/11/201801:12:0001:12:00
STAFF105/11/2018 16:1005/11/2018 18:0105/11/201805/11/201801:51:0001:51:00
STAFF106/11/2018 16:0806/11/2018 17:2706/11/201806/11/201801:19:0001:19:00
STAFF107/11/2018 16:0407/11/2018 17:5307/11/201807/11/201801:49:0001:49:00
STAFF108/11/2018 16:0808/11/2018 18:0508/11/201808/11/201801:57:0001:57:00
STAFF112/11/2018 16:0712/11/2018 18:1612/11/201812/11/201802:09:0002:09:00
STAFF113/11/2018 16:2613/11/2018 17:4613/11/201813/11/201801:20:0001:20:00
STAFF115/11/2018 16:1015/11/2018 18:0615/11/201815/11/201801:56:0001:56:00
STAFF116/11/2018 16:0516/11/2018 16:2616/11/201816/11/201800:21:0000:21:00
STAFF120/11/2018 16:0420/11/2018 17:2620/11/201820/11/201801:22:0001:22:00
STAFF121/11/2018 16:1321/11/2018 17:4221/11/201821/11/201801:35:0001:29:00
STAFF121/11/2018 17:4221/11/2018 17:5421/11/201821/11/201801:35:0000:12:00
STAFF122/11/2018 16:0922/11/2018 17:3222/11/201822/11/201801:23:0001:23:00
STAFF126/11/2018 16:0826/11/2018 18:0626/11/201826/11/201801:58:0001:58:00
STAFF103/12/2018 16:2603/12/2018 17:5003/12/201803/12/201801:24:0001:24:00

 

thanks!