How to show in filter all listed countries from country table and the fact table country filed is missing country name since no data for those.

[MEDHA07]

Hi All,

My main table has country filed and it showing around 50 countries since it has data.but user need all countries should be listed in filter which are not even coming in the main table.

I have country table which has all list of countries.

when we join both i am getting only 50 countries in the list because of association .

in filter pane it should all listed countries.

COUNTRY:

Load

country_code,

Country

from[lib:/ country.qvd]

Main Table:

Id,

values,

country_code,

Country

From ...........;

[Or]

This is how Qlik works by default. In the scenario you described above, it should list all countries from either table unless something is preventing it from doing so (which could be a directional join, section access, or whatnot).