I'm looking to build a sankey diagram that has 3 or more dimensions. Each of these dimensions will reduce the amount count of records as they go along. I want to be able to remove any NULL values for the 3rd dimension but still keep the total record count for the first and second dimensions the same. The screenshot is from Sankey in Qlik Sense. The large red bar is all NULL so I don't want them showing.
The first dimension has 5 categories. The second dimension has 6 categories. The third dimension will have 4 categories.
The first dimension will flow into each of the 6 categories in the second dimensions but only 1 of the categories in the second dimension will flow into the 4 categories of the third dimension. Below is a screenshot (from Power BI) of what I want to do in Qlik Sense Cloud.
Is there a way to do this?