Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rustyfishbones
Master II
Master II

Help with an expression

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.

 

TaskDescriptionTaskOperatorTaskEndTimeDateONLY({<[date-added] = {'25/06/2018'}>}TaskStartTime)
PickingHyfb Qiheepzq10:04:0025/06/201808:33:00
BREAK/LUNCHHyfb Qiheepzq10:15:0025/06/201810:04:00
PickingHyfb Qiheepzq13:04:0025/06/201810:15:00
BREAK/LUNCHHyfb Qiheepzq13:38:0025/06/201813:04:00
PickingHyfb Qiheepzq15:12:0025/06/201813:38:00
BREAK/LUNCHHyfb Qiheepzq15:23:0025/06/201815:12:00
PickingHyfb Qiheepzq15:23:0025/06/201815:23:00
PickingJfkee Inpqdc10:05:0025/06/201807:31:00
BREAK/LUNCHJfkee Inpqdc10:20:0025/06/201810:05:00
PickingJfkee Inpqdc12:39:0025/06/201810:20:00
BREAK/LUNCHJfkee Inpqdc13:18:0025/06/201812:39:00
PickingJfkee Inpqdc13:18:0025/06/201813:18:00
1 Solution

Accepted Solutions
captain89
Creator
Creator

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])

View solution in original post

11 Replies
sunny_talwar

May be this

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

rustyfishbones
Master II
Master II
Author

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

sunny_talwar

What is the issue still?

rustyfishbones
Master II
Master II
Author

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
Master II
Master II
Author

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

rustyfishbones
Master II
Master II
Author

I am missing some records

2018-06-25_1705.png

sunny_talwar

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

captain89
Creator
Creator

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
Master II
Master II
Author

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

2018-06-25_1721.png