Discussion Board for collaboration related to QlikView App Development.
I've a requirement where the employee is aligned to multiple entities over a period of time, but I need to show up only the entity he is into the latest date. Sample data is below.
Expected result is below
Please note this needs to be achieved at chart level. Also the fields till assignment date should be as dimensions whereas the standard hours is the measure.
Thanks in advance
May be try this
FirstSortedValue([Entity name], -[Assignment Start Date])
Max([Assignment Start Date])
FirstSortedValue([Standard Hours], -[Assignment Start Date])
Aggr(FirstSortedValue([Entity name], -[Assignment Start Date]), [Employee No])
Date(Aggr(Max([Assignment Start Date]), [Employee No]))
any specific reason behind assignment start date as dimension???
you can use max() if you want to use it as measure..
you can try it with aggregation:
For example something like aggr(max([Assignment Start Date]),[Employee Name])