topic Re: Highest count in QlikView

Highest count

Mon, 26 Jan 2026 18:19:17 GMT

Hi guys need some help please.

I have list of SuperKey's that have more than one Route-ID. Basically I only need to see the line with highest count which in this case is line 1. How can I achieve this?

SuperKey	ROUTE_ID	RouteID Count
USAA2000045621OS030C2610	WHG03	528
USAA2000045621OS030C2610	WHG02	192

Regards,

Raj

Re: Highest count

Gysbert_Wassenaar — Thu, 18 Feb 2016 18:21:50 GMT

Try these two expressions:

=Max([RouteID Count])

=FirstSortedValue(ROUTE_ID, -[RouteID Count])

Re: Highest count

sunny_talwar — Thu, 18 Feb 2016 18:22:05 GMT

May be do something like this:

Table:

LOAD SuperKey,

ROUTE_ID

[RouteID COUNT]

FROM Source;

Right Join(Table)

LOAD SuperKey,

Max([RouteID COUNT]) as [RouteID COUNT]

Resident Table

Group By SuperKey;

Re: Highest count

Sat, 20 Feb 2016 18:47:30 GMT

Hi both thank you for the quick reply highly appreciate it. I am still working on it as there are some changes in the requirement. I will soon check and let u know if i am successful

Thanks a lot

Re: Highest count

Thu, 25 Feb 2016 21:31:54 GMT

Thanks guys both solutions are great and first one fits my current requirement.

Sunny T solution may not be used for now but will definitely be useful in future.

Re: Highest count

sunny_talwar — Fri, 26 Feb 2016 00:51:46 GMT

Glad we were able to help