Block a dimension in a PIVOT TABLE

Mon, 25 Jan 2016 09:16:56 GMT

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?

Re: Block a dimension in a PIVOT TABLE

marcus_sommer — Mon, 25 Jan 2016 12:16:05 GMT

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

topic Re: Block a dimension in a PIVOT TABLE in QlikView

Block a dimension in a PIVOT TABLE

Re: Block a dimension in a PIVOT TABLE