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