Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ext_bks
Employee
Employee

Set Modifier on Dimension

I want to use StoreName as a filter pane in a comparative analysis. I first have a default state and then broken down to two State1 and State2. The StoreName has to be State1 for example, but it also has to inherit from default state.

 

Using the logic similar for the measure sum({"State1"<State = $::State>}TOTALSALSAMOUNT), I'd like to apply this state logic on StoreName which will be used in a filter. How do I achieve this? 

I've tried something like =Upper($({"State1"<State = $::State>}),STORE_DESC) where it comes out correctly in the expression editor but the on filter pane settings it shows invalid dimension.

 

Labels (3)
0 Replies