Max / GROUP BY

[Prabhu1204]

Hi,

i have a data with ID, Status, Priority and phase. In qlik the output should be like,

I have to take the maximum priority and corresponding phase for the status complete Is it possible to show like below expected output image

[Prabhu1204]

@MayilVahanan 

Can you help

[MayilVahanan]

Hi @Prabhu1204 ,

Try like below

Temp:
Load * Inline
[
ID Priority Status Phase
1 2 Compelte Review
1 5 Compelte Contract
1 4 Compelte Approva
1 1 Compelte sign
2 2 Compelte Review
2 5 Compelte Contract
2 7 Compelte Approva
2 8 Open Close
2 9 Open
](delimiter is ' ');

Load
ID, FirstSortedValue(Phase, -Priority) as FinalPhase Resident Temp where Status = 'Compelte'
group by ID;

[Prabhu1204]

For some reasons It is not working. I have many fields other than Id field like, date, department. etc.. is ther any approach which can be implemented in UI

[MayilVahanan]

Might be,

try like below

FirstSortedValue(Phase, -Aggr(Max({<Status={"Compelte"}>} Priority), Priority, ID))

[Prabhu1204]

Hi I tried and for some reason it is not working for few id, Not sure why