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.

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

Sankey chart count not as expected

Hi,

 

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