Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Block a dimension in a PIVOT TABLE

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?

1 Reply
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