Dynamic measures based on the filter pane options

[tas_taba1]

Hello Qlikkers,

I am facing a complication in my qlik sense app. I have multiple filter panes with different fields. Now, I want a table that will have different measures based on which filter pane value I am choosing the filters from. For example-

filter panes and tables

The expression for SE measure in the tables are- 

"=Sqrt(Sum( {1} Aggr(
((sqr(Sum(UtilityWt) - Sum(Total <CinemaStratum,Race> UtilityWt)/Count(DISTINCT ALL <CinemaStratum> CinemaPSU))) * (Count(DISTINCT ALL <CinemaStratum> CinemaPSU)/(Count(DISTINCT ALL <CinemaStratum> CinemaPSU)-1)))
, Race, CinemaStratum, CinemaPSU)))/4"

problem

But I want the measure to be-

"=Sqrt(Sum( {1} Aggr(
((sqr(Sum(UtilityWt) - Sum(Total <CinemaStratum,Race> UtilityWt)/Count(DISTINCT ALL <CinemaStratum> CinemaPSU))) * (Count(DISTINCT ALL <CinemaStratum> CinemaPSU)/(Count(DISTINCT ALL <CinemaStratum> CinemaPSU)-1)))
, Race, CinemaStratum, CinemaPSU)))"

if I choose a filter from the filter pane- CinemaValue.

Any help is greatly appreciated.

I am attaching the dummy app for convenience. Thank you.

[GaryGiles · Accepted solution]

Have you tried using =if(getselectedcount(CinemaValue)=0, first expression, second expression)

[tas_taba1]

Hi @GaryGiles , thank you! That worked.