Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
CasperQlik
Creator
Creator

Sankey chart and null values behaviour

Hi Qlik Community

I hope you can help me with an Issue I have with the sankey chart and null values.


As you can see below I have my data segmented in different levels from 1-5 (name-name4). Not all entries have values in all fields.

I don't understand how the sankey chart behaves. I would expect that when there is no data in columns (null values) beyond a certain point that the "flow" would simple stop at the level with the latest entry.

However the "flow" continues in with the null values. See marked with yellow.

sandkey 1.png

And this leads me to another problem. If I use the function to not show null values in the chart, for some reason, Qlik removes the entire row with any null value present and not just the specific columns. See below. This is how the chart looks if I check don't show nulls.

CasperQlik_0-1694517179484.png

Any help is appreciated

Casper

 

0 Replies