QlikView App Dev

[rustyfishbones]

Hi All,

I have the following expression.

ONLY({<[date-added] = {'$(=DATE(MAX([date-added])))'}>}TaskStartTime)

the expression returns the following data, I only want the first time for each operator for that day, see in bold.

TaskDescription	TaskOperator	TaskEndTime	Date	ONLY({<[date-added] = {'25/06/2018'}>}TaskStartTime)
Picking	Hyfb Qiheepzq	10:04:00	25/06/2018	08:33:00
BREAK/LUNCH	Hyfb Qiheepzq	10:15:00	25/06/2018	10:04:00
Picking	Hyfb Qiheepzq	13:04:00	25/06/2018	10:15:00
BREAK/LUNCH	Hyfb Qiheepzq	13:38:00	25/06/2018	13:04:00
Picking	Hyfb Qiheepzq	15:12:00	25/06/2018	13:38:00
BREAK/LUNCH	Hyfb Qiheepzq	15:23:00	25/06/2018	15:12:00
Picking	Hyfb Qiheepzq	15:23:00	25/06/2018	15:23:00
Picking	Jfkee Inpqdc	10:05:00	25/06/2018	07:31:00
BREAK/LUNCH	Jfkee Inpqdc	10:20:00	25/06/2018	10:05:00
Picking	Jfkee Inpqdc	12:39:00	25/06/2018	10:20:00
BREAK/LUNCH	Jfkee Inpqdc	13:18:00	25/06/2018	12:39:00
Picking	Jfkee Inpqdc	13:18:00	25/06/2018	13:18:00

[sunny_talwar]

May be this

If(TaskStartTime = Min(TOTAL <TaskOperator> {<[date-added] = {'25/06/2018'}>}TaskStartTime), TaskStartTime)

[rustyfishbones]

Thanks Sunny, but that does not give me the correct data, it close but not correct

[sunny_talwar]

What is the issue still?

[rustyfishbones]

Ok I think I have it, the table contained additional dimensions the below seems correct.

If(TaskStartTime = Min(TOTAL <TaskOperator,[date-added],TaskDescription> {<[date-added] = {'$(=DATE(MAX([date-added])))'}>}TaskStartTime), TaskStartTime)

[rustyfishbones]

Actually thats not quite correct..... mmm...

[rustyfishbones]

I am missing some records

[sunny_talwar]

I am not sure what is wrong by looking at the image... can you elaborate what is missing?

[captain89 · Accepted solution]

Hi,

you can use the min expression with aggr in this case:

aggr(min({<[date-added]={'26/06/2018'}>} HH), TaskOperator, [date-added])

maybe if you delete the set analysis part you can show the min of a selected date:

aggr(min(HH), TaskOperator, [date-added])

[rustyfishbones]

Hi Sunny see below image i need to see 06:27:00 as the TaskStartTime, with your expression I get no records when I select a TaskOperator