Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

MarvelousMar
New 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!