Set analysis to show top performing country and should neglect all selections

Qlikuser225 — Tue, 25 Feb 2025 19:15:35 GMT

Hello,

I want to show a ref line in gauge chart in qlik sense which shows top performing country per selected month (default is current month) and it should not change if i select other countries.

Load * inline [

Country Records Month

USA 11 Feb-2025

Brazil 9 Feb-2025

Canada 8 Feb-2025

USA 9 Jan-2025

Brazil 20 Jan-2025

Canada 13 Jan-2025

I want to show Ref line with 11 on gauge chart for Feb-2025 and it should not change if i select Canada or Brazil. Same as Ref line should be 20 for Jan-2025 and it should not change if i select USA or Canada.

Can anyone pls help me with this?

Thanks in Advance

Re: Set analysis to show top performing country and should neglect all selections

Chanty4u — Wed, 26 Feb 2025 03:39:40 GMT

Try this

Max({<Country=, Month=P(Month)>} Aggr(Sum(Records), Country, Month))

topic Re: Set analysis to show top performing country and should neglect all selections in App Development

Set analysis to show top performing country and should neglect all selections

Re: Set analysis to show top performing country and should neglect all selections