Discussion Board for collaboration related to QlikView Deployment.
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?
Go to Solution.
Try these two expressions:
=FirstSortedValue(ROUTE_ID, -[RouteID Count])
May be do something like this:
Max([RouteID COUNT]) as [RouteID COUNT]
Group By SuperKey;
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
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.
Glad we were able to help