topic Re: Finding two min values within the aggr class. in QlikView

Finding two min values within the aggr class.

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Question: Below is the input table having following 3 fields.

I have to show min sum value, aggregated based on the Class field.

From the Class which is giving min sum value, i have to find out two min values showing the country name along with the value.

I had worked on the Straight table and achieved to get the following result.However it is also showing the values for other class also.

Later, I tried to implement it on text box which is showing the class name having min sum values .However it is showing value from other class also.

I want to show following result.

Please guide me how do we achieve this.

Thanks!!!!

Kushal_Chawda — Thu, 29 Jun 2017 16:56:02 GMT

Do you want this logic in script?

Anil_Babu_Samineni — Thu, 29 Jun 2017 17:13:44 GMT

How about v222??

Kushal_Chawda — Thu, 29 Jun 2017 17:16:52 GMT

try this expression

FirstSortedValue(Class,aggr(sum(Value),Class)) & chr(10) &

min({<Class={"$(=FirstSortedValue(Class,aggr(sum(Value),Class)))"}>}Value) & ' ' &

FirstSortedValue(Country, aggr(min({<Class={"$(=FirstSortedValue(Class,aggr(sum(Value),Class)))"}>}Value) ,Class,Country))& chr(10) &

FirstSortedValue(aggr(min({<Class={"$(=FirstSortedValue(Class,aggr(sum(Value),Class)))"}>}Value),Class,Country) ,

aggr(min({<Class={"$(=FirstSortedValue(Class,aggr(sum(Value),Class)))"}>}Value),Class,Country),2) & ' ' &

FirstSortedValue(Country,aggr(min({<Class={"$(=FirstSortedValue(Class,aggr(sum(Value),Class)))"}>}Value),Class,Country),2)

Anonymous — Fri, 30 Jun 2017 05:44:58 GMT

@kushal chawda

Thanks for the solution. Its working as expected.

Kushal_Chawda — Fri, 30 Jun 2017 09:01:48 GMT

Glad to help