Sankey chart by % Split

guster999 — Fri, 27 Jun 2025 02:50:27 GMT

Hi , I have a query on Qlik sense Sankey charts and how to display the correct % split for both the dims I'm using.

my chart below is correct for WFA Area dimension as Totals to 100% and also if i select the flow branches they show the correct split. eg Wairarapa-ED = 38%.

The measure code is: =Count(distinct Master_Incident_Number)/count(total <WFA_Area> distinct Master_Incident_Number)

But how can I also get the DestinationType dim to show correct in adding to 100%. eg % values from each of the WFA Areas, as you can see it adds to way more than that.

thankyou.

Re: Sankey chart by % Split

seanbruton — Wed, 02 Jul 2025 14:00:01 GMT

Hi,

I think that the challenge is that the incident number can appear in multiple outcomes in the other dimensions. This will mean that distinct in the right has a higher number in total.

I suggest trying this which worked for me in my testing:

=Count(distinct [Master_Incident_Number]&[WFA Area]&[Destination Type])

count(total distinct [Master_Incident_Number]&[WFA Area]&[Destination Type])

Regards

topic Re: Sankey chart by % Split in App Development

Sankey chart by % Split

Re: Sankey chart by % Split