Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!
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: