Block a dimension in a PIVOT TABLE

[#1]

Good Morning Community!

I have the following question:

What I have to do if I want the same dimesion even there is no value for one field?

My dimesion is COUNTRY ("PAIS" in spanish)

If I want a dimesion with image I introduce the following sentence:

=IF(PAÍS='USA','qmem://Nombre/USAico',

  IF(PAÍS='URUGUAY','qmem://Nombre/URUico',

  IF(PAÍS='UK','qmem://Nombre/UKico',

  IF(PAÍS='PORTUGAL','qmem://Nombre/PORico',          

  IF(PAÍS='POLONIA','qmem://Nombre/POLico',

  IF(PAÍS='MÉXICO','qmem://Nombre/MEXico' ,

  IF(PAÍS='ESPAÑA','qmem://Nombre/ESPico',

  IF(PAÍS='CHILE','qmem://Nombre/CHIico',

  IF(PAÍS='BRASIL','qmem://Nombre/BRAico',

  IF(PAÍS='ARGENTINA','qmem://Nombre/ARGico',

  IF(PAÍS='ALEMANIA','qmem://Nombre/GERico',

  IF(PAÍS='SCF','qmem://Nombre/Wrong',

  IF(PAÍS='PUERTO RICO','qmem://Nombre/PURico')))))))))))))

So the problem is that when I choose one option in the filtres (Nivel 1) in the attached image there are no options for some countries SCF and Puerto Rico so there are no images for these countries in the dimension.

But instead if I use "PAIS" as Dimension I can see all of them even there are no values.

Any idea?

[marcus_sommer]

I would think to have the image-url's within an additionally table like:

CountryUrl:

Load * Inline [

PAÍS, Url

USA, qmem://Nombre/USAico

....

];

and then an expression like: only({1} Url) and with the set analysis identifier of {1} you wil be independent from selections.

- Marcus