Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MEDHA07
Contributor III
Contributor III

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.

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 ...........;

Labels (1)
1 Reply
Or
MVP
MVP

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).