Solved: Re: Calculation - Qlik Community

rido1421 · ‎2018-10-04

Hi There

I am trying to find the income class with the highest number of households in each suburb.

I would like to create an expression that will display the suburbs with the income class with highest no of households

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

I have attached the data and qvw , please assist

regards

Anil_Babu_Samineni · ‎2018-10-04

May be try this?

=FirstSortedValue([Income Class], -Aggr(Sum([No of Households]), Suburb, [Income Class]))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Anil_Babu_Samineni · ‎2018-10-04

May be try this?

=FirstSortedValue([Income Class], -Aggr(Sum([No of Households]), Suburb, [Income Class]))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

rido1421 · ‎2018-10-04

Thanks you works perfectly

Calculation

Related Topics