Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Dynamic measures based on the filter pane options

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 tablesfilter 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"

problemproblem

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.

Labels (2)
1 Reply
Highlighted
Contributor III
Contributor III

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