Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Background colour change upon selection - Map

Hi all

I have a below expression that displays the Location name with Rank 1 in a text box correctly. I also have a map that displays multiple locations (multiple bubbles). When the text box is selected I would need the bubble to change the colour to green (rank 1 location to change to green). I have used the second expression below as the background expression in the chart.

Expression in text box to display Location name with Rank 1:

FirstSortedValue({<Location= >}Location,-aggr(sum({<Location= >}[Actual]),Location),1),

Background clolour expression in chart:

if(Location=FirstSortedValue({<Location= >}Location,-aggr(sum({<Location= >}[Actual]),Location),1), green(),red())

Regards

Kush.

0 Replies