Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Display two dimensions from two different table into one Selector

I have to create a selector in the App, which should display two dimensions. These two dimensions are available in two different tables.


Metric  Value

Estimated/Final Pat Rev ,100


Final Net Pat Rev Value

Final Net Pat Rev, 1002


I tried with if condition, which displays but when we make the selection, it will select both the dimensions because they are both are present in the table

if(Metric='Estimated/Final Pat Rev',Metric,if([Final Net Pat Rev]='Final Net Pat Rev',[Final Net Pat Rev]))

Kindly, please help me to resolve the issue.


1 Reply

Re: Display two dimensions from two different table into one Selector

If you can't put them in a common table then I would suggest a link table.

Metric as Dimension,
Null () as [Final Net Pat Rev]
From Table1;
Concatenate (Link) load
[Final Net Pat Rev] as Dimension,
[Final Net Pat Rev],
Null() as Metric
From Table2;

Make your selections eon the Dimension field.
Plees ekskuse my Swenglish and or Norweglish spelling misstakes