Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Highest count

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?

   

SuperKeyROUTE_ID RouteID Count
USAA2000045621OS030C2610WHG03528
USAA2000045621OS030C2610WHG02192

Regards,

Raj

1 Solution

Accepted Solutions

Re: Highest count

Try these two expressions:

=Max([RouteID Count])

=FirstSortedValue(ROUTE_ID, -[RouteID Count])

talk is cheap, supply exceeds demand
5 Replies

Re: Highest count

Try these two expressions:

=Max([RouteID Count])

=FirstSortedValue(ROUTE_ID, -[RouteID Count])

talk is cheap, supply exceeds demand
MVP
MVP

Re: Highest count

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;

Not applicable

Re: Highest count

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

Not applicable

Re: Highest count

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.

MVP
MVP

Re: Highest count

Glad we were able to help