Sankey Diagram Visual

[RobO]

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?

[William11]

Yes, you can definitely replicate that type of multi-level flow in Qlik Sense Cloud. To build a similar structure, you’ll need to use a Sankey diagram extension (like the one available in the Visualization Bundle or a custom extension from Qlik’s Developer Hub).

Here’s the basic approach:

1. Prepare your data model so that it clearly defines the three dimensions and their relationships (e.g., Category1 → Category2 → Category3).
2. Load the data with proper key fields that represent each connection between dimensions.
3. Use the Sankey chart and assign:
   • Source: your first and second dimensions
   • Target: your second and third dimensions
   • Measure: a numeric field representing the flow value or count

Since only one of your second-dimension categories needs to connect to the third dimension, you can manage this easily by using a conditional expression or filtering the data before loading it into the Sankey.

To get a visual idea of how this flow should look, you can check this interactive example:
👉 https://app.powerbi.com/view?r=eyJrIjoiOTEzZTdjZGUtNzE5MS00ODk2LWJkOTAtNTI3ZjMwNWI1MTdhIiwidCI6IjYy…

That example shows a similar multi-layer flow setup that matches what you’re describing.

Hope this helps you get the structure right in Qlik Sense!

— Rob