Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Sankey chart count not as expected



I'm trying to create a sankey chart to show data region and few columns as second dimension.

First dimension: Region

Second Dimension is below expression:

=if(BS='Yes' ,'BS',if(NF='Yes' ,'NF',
if(Both='Yes' ,'Both',if(NT='Yes' ,'NT',if(RE='Yes' ,'RE',
if(GD='Yes' ,'GD',if(DA='Yes' ,'DA',)))))))

Measure: Count(Key)

Below is the sample Data.

Issue is when first  column BS is Yes  and if NF is Yes the count for NF is not considered as it is already considering it for BS. can you any one say how to resolve this issue to show count of each column when it is 'Yes' in sankey chart? 

Below is the column order.

KeyRegionBSNFBothNTREGDDACurrent Year Scope


Sample data is attached.



Labels (3)
0 Replies