Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

rustyfishbones
Honored Contributor 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
Tags (2)
1 Solution

Accepted Solutions
captain89
Contributor

Re: Help with an expression

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

Re: Help with an expression

May be this

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

rustyfishbones
Honored Contributor II

Re: Help with an expression

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

Re: Help with an expression

What is the issue still?

rustyfishbones
Honored Contributor II

Re: Help with an expression

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
Honored Contributor II

Re: Help with an expression

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

rustyfishbones
Honored Contributor II

Re: Help with an expression

I am missing some records

2018-06-25_1705.png

Re: Help with an expression

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

captain89
Contributor

Re: Help with an expression

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

rustyfishbones
Honored Contributor II

Re: Help with an expression

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