Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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.

Table1:

Metric  Value

Estimated/Final Pat Rev ,100

Table2:

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
Highlighted
Partner
Partner

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.

Link:
Load
Metric as Dimension,
Metric,
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