Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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
Might be,
try like below
FirstSortedValue(Phase, -Aggr(Max({<Status={"Compelte"}>} Priority), Priority, ID))
Hi I tried and for some reason it is not working for few id, Not sure why