topic Default expression but change upon user selection in QlikView

Default expression but change upon user selection

Kwame — Thu, 25 May 2023 09:46:22 GMT

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.

Re: Default expression but change upon user selection

Aditya_Chitale — Fri, 26 May 2023 08:59:49 GMT

Use below measure expression :

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

Regards,

Aditya