Null Values in Pivot Table

[gabriele_qlik]

Hi everyone,

I have a pivot table with 4 dimensions. Dimensions show also null values. For example:

Business Unit           Region           Cluster           Market

A                                     Europe          Null                 Italy

A                                     Europe          Null                 Germany

A                                     Europe          B2                    France

A                                     Europe          A56                  Spain

In this case I want that when I expand Europe, the table has to show Cluster B2 and A56 but instead of Null valus it has to show Italy and Germany. In addition to this, when I expand Europe, the table has to give me the possibility to expand Cluster B2 and A56 but not the possibility to expand Italy and Germany. In other words, when there are null values the table has to jump to the following dimension (Market in this case). I would have a situation like this:

A

      Europe

                        Italy

                        Germany

                        B2

                        A56

with the possibility to expand only B2 and A56.

Thank you

Gabriele

[Sue_Macaluso]

@gabriele_qlik  Hi, are you using QlikView or Sense?  I would like to move this into the correct product forum. 

[H_Julian]

Hey,

Instead of the Dimension "Cluster", just do the following:

1. Dimension:Business Unit

2. Dimension: Region

3. Dimension: if(isnull(Cluster),Market,Cluster)

4. Dimension:Market

Greetings