topic Calculation in QlikView https://community.qlik.com/t5/QlikView/Calculation/m-p/136084#M20381 <HTML><HEAD></HEAD><BODY><P>Hi There </P><P></P><P>I am trying to find the income class with the highest number of households in each suburb.</P><P>I would like to create an expression that will display the suburbs with the income class with highest no of households</P><P></P><P>I have tried it in the attached sample but its not working correctly if there are no selections, I want to display this for all suburbs</P><P>I have attached the data and qvw , please assist</P><P></P><P>regards</P></BODY></HTML> Thu, 04 Oct 2018 13:43:47 GMT rido1421 2018-10-04T13:43:47Z Calculation https://community.qlik.com/t5/QlikView/Calculation/m-p/136084#M20381 <HTML><HEAD></HEAD><BODY><P>Hi There </P><P></P><P>I am trying to find the income class with the highest number of households in each suburb.</P><P>I would like to create an expression that will display the suburbs with the income class with highest no of households</P><P></P><P>I have tried it in the attached sample but its not working correctly if there are no selections, I want to display this for all suburbs</P><P>I have attached the data and qvw , please assist</P><P></P><P>regards</P></BODY></HTML> Thu, 04 Oct 2018 13:43:47 GMT https://community.qlik.com/t5/QlikView/Calculation/m-p/136084#M20381 rido1421 2018-10-04T13:43:47Z Re: Calculation https://community.qlik.com/t5/QlikView/Calculation/m-p/136085#M20382 <HTML><HEAD></HEAD><BODY><P>May be try this?</P><P></P><P><STRONG>=FirstSortedValue([Income Class], -Aggr(Sum([No of Households]), Suburb, [Income Class]))</STRONG></P></BODY></HTML> Thu, 04 Oct 2018 13:53:17 GMT https://community.qlik.com/t5/QlikView/Calculation/m-p/136085#M20382 Anil_Babu_Samineni 2018-10-04T13:53:17Z Re: Calculation https://community.qlik.com/t5/QlikView/Calculation/m-p/136086#M20383 <HTML><HEAD></HEAD><BODY><P>Thanks you works perfectly</P></BODY></HTML> Thu, 04 Oct 2018 14:59:36 GMT https://community.qlik.com/t5/QlikView/Calculation/m-p/136086#M20383 rido1421 2018-10-04T14:59:36Z