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: 
Kwame
Contributor III
Contributor III

Default expression but change upon user selection

Hi guys!

My goal is to default a location, say Sum({<Location={'Africa'}>} Sales) but it should change based on the user's selection in the location filter consisting of other continents.

Appreciate the help.

1 Reply
Aditya_Chitale
Specialist
Specialist

Use below measure expression :

if(getselectedcount(Location), sum(Sales), Sum({<Location={'Africa'}>} Sales))

Regards,

Aditya