Default expression should change upon user selection

Kwame — Thu, 25 May 2023 12:28:29 GMT

Hi guys!

My goal is to set the expression as the default value, but it should also change based on user selection.

This is what I tried, but it didn't work.

Sum({<Location *={'Africa'}>} Sales)

So basically the user needs to be able to get e.g. Sales from other continents by selecting from the location filter and if no selection is made, the expression should return sales for Africa.

Re: Default expression should change upon user selection

Aditya_Chitale — Fri, 26 May 2023 06:32:36 GMT

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

Regards,

Aditya

topic Re: Default expression should change upon user selection in QlikView

Default expression should change upon user selection

Re: Default expression should change upon user selection