topic Re: Null Values in Pivot Table in Water Cooler

Null Values in Pivot Table

gabriele_qlik — Fri, 07 Feb 2020 22:15:01 GMT

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:

Europe

Italy

Germany

A56

with the possibility to expand only B2 and A56.

Thank you

Gabriele

Re: Null Values in Pivot Table

Sue_Macaluso — Fri, 13 Sep 2019 16:13:10 GMT

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

Re: Null Values in Pivot Table

H_Julian — Thu, 09 Jan 2020 12:04:53 GMT

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