Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gabriele_qlik
Contributor III
Contributor III

Null Values in Pivot Table

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

 

Labels (1)
  • Other

2 Replies
Sue_Macaluso
Community Manager
Community Manager

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

Sue Macaluso
H_Julian
Contributor III
Contributor III

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