Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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
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

May be this

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

Master II
Master II

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

What is the issue still?

Master II
Master II

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)

Master II
Master II

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

Master II
Master II

I am missing some records

2018-06-25_1705.png

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

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

Master II
Master II

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