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
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
MarvelousMar
Contributor
Contributor

FIRST DATA FIELD IS BASED FROM THE SECOND DATA FROM PICKING ONE OF THE TWO DIFFERENT DIMENSIONS

Hi Everyone,

I have an issue that seems easy, but it is a pain. 

I have a field name "Region" and Active Dimension1 with two different fields named "Countries Table 1" and "Countries Table 2".

When I select the dimension of "Countries Table 1" the "Region" field should reflect those numbers. When I select "Countries Table 2" then the "Region" field should reflect those numbers. 

I have used these functions below, but none have changed the numbers for the "Region" field.

= dual (REGION, ActiveDimension1)

= if(WildMatch(GetCurrentSelections(ActiveDimension1),'Countries Table 1'), [Countries Table 1], REGION)

=  dual (REGION, if(GetCurrentSelections(ActiveDimension1) = 'Countries Table 1', [Countries Table 1], [Countries Table 2]) )

The Region field represent sections like Asia, North America, Europe, etc.

The Countries Table 1 and 2 lists individual countries but hold different dataset. 

Any help is greatly appreciated. Thanks!

 

0 Replies