Max and Min date & time in each day

[Student]

Hi, please help  with this task:

build table in Qlickview with worker ID by each day with Min and Max timestamp from row data it the examples below.

Can someone help with some ideas?

row dataexample of report

• Add to Phrasebook
  • No word lists for English -> Russian...
  • Create a new word list...
• Copy

• Add to Phrasebook
  • No word lists for English -> Russian...
  • Create a new word list...
• Copy

• Add to Phrasebook
  • No word lists for English -> Russian...
  • Create a new word list...
• Copy

[Saravanan_Desingh]

Can you attach the sample spreadsheet?

[vamsee · Accepted solution]

Try

A:
NoConcatenate
Load
	Date(Timestamp#(Timestamp, 'MM/dd/yyyy hh:mm:ss TT')) as Date,
	Timestamp(Timestamp#(Timestamp, 'MM/dd/yyyy hh:mm:ss TT')) as Time_stamp,
	Worker
Resident Source
;
Drop Table Source;


Aggr:
NoConcatenate
Load 
		Date,
		Worker, 
		Time(Min(Time_stamp)) as Min_Value,
		Time(Max(Time_stamp)) as Max_Value
Resident A
Group By
		Date,
		Worker
;
Drop Table A;

[Brett_Bleess]

If Vamsee's post got you what you needed, we would greatly appreciate it if you would close out your thread by using the Accept as Solution button on that post to mark it as the solution.  This gives the poster credit for the help and lets the other Community Members know that it did work.  If you are still working upon things, please leave an update post on what you still need.

Regards,
Brett