Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rido1421
Creator III
Creator III

Calculation

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

1 Solution

Accepted Solutions
Anil_Babu_Samineni

May be try this?

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

2 Replies
Anil_Babu_Samineni

May be try this?

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
rido1421
Creator III
Creator III
Author

Thanks you works perfectly