Sankey chart by % Split

[guster999]

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.

[seanbruton · Accepted solution]

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