topic Re: Max / GROUP BY in QlikView

Max / GROUP BY

Prabhu1204 — Sun, 12 Jun 2022 09:24:54 GMT

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

Re: Max / GROUP BY

Prabhu1204 — Sun, 12 Jun 2022 09:25:42 GMT

@MayilVahanan

Can you help

Re: Max / GROUP BY

MayilVahanan — Sun, 12 Jun 2022 13:17:00 GMT

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;

Re: Max / GROUP BY

Prabhu1204 — Mon, 13 Jun 2022 03:26:54 GMT

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

Re: Max / GROUP BY

MayilVahanan — Mon, 13 Jun 2022 08:50:13 GMT

Might be,

try like below

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

Re: Max / GROUP BY

Prabhu1204 — Thu, 16 Jun 2022 10:04:29 GMT

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