Flag instance with max value

FernandaNava — Sat, 16 Nov 2024 18:05:41 GMT

I have a table with several fields that include:

A unique ID

An "Event" ID

A "Time" column with a numeric value for days

-several others

I would like to flag, for each "event" ID, the occurrence with the largest value for "Time"

I'm trying the solution suggested by this post but I've had some issues. At first I couldn't get the MAX() function to work within qlik so I did it through SQL. Now this part works but when I do the join to add the flags, it is added to every line.

Any suggestions to fix this solution or maybe an idea for a different one?

Thank you,

Re: Flag instance with max value

sunny_talwar — Thu, 17 Sep 2020 19:25:12 GMT

May be try like this

Table: LOAD ID, Event_ID, Time, ... From ...; Left Join (Table) LOAD ID, Max(Time) as Time, 1 as Max_Event Resident Table Group By ID;

topic Re: Flag instance with max value in App Development

Flag instance with max value

Re: Flag instance with max value