Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Null dimension values in pivot table

Hi,

I have three dimensions in pivot table (all as rows). My dimensions display hierarchy levels that partially have null values (the 1. level does not have nulls, but the 2. and 3. level have, I have loaded the data as inline load and defined there to be null  values if empty/no level). When I display the three levels as indent rows it also shows the null values.

My problem is that when I untick the include null values -box from the second or third dimensions, the dimensions also disappear. So not only the null values disappear, but all the dimension values.  Is there a way to go around this or am I doing something wrong?

BR,

AJM

4 Replies
Highlighted
Partner
Partner

Re: Null dimension values in pivot table

Hi,

a possible workaround is about mapping null values inside the script

Highlighted
Partner
Partner

Re: Null dimension values in pivot table

Thank You for your answer! If I map null values, I guess I would still have the problem that I have to show something that I do not want to. In my pivot table I would like to show the second and third dimensions if there is a value and if not, I do not want to show anything (so if I would use null mapping, there would be something to show, but I would have to hide it somehow?). Is there a way with null mapping to hide the originally null dimension values in some way after I have done the mapping?

Highlighted
Partner
Partner

Re: Null dimension values in pivot table

I think that you couldn't have a table in which some rows has 3 dimension, and others 1 or 2 at the same time.

 

Maybe try to use condition of each column, for example:

1) Len(field)<>0: dimensions disappear and, if you select rows that have value, column will be show

2) You could create a button that allow to show/hide column

 

Highlighted
Partner
Partner

Re: Null dimension values in pivot table

Thank You again! I will try those out and see how I can make them work. I was thinking about changing these hiearchies that I have, but for some level 1's and level 2's there is no real life equivalents for level 2's and level 3's, so I am hoping that your solutions could work.