Qliksense Sankey chart to display each dimension top 10

[nvijay5757]

Hi in Qliksense Sankey chart, in my chart 5 Dimensions each Dimension to display Top 10 please help me

#Sankey chart

[abhijitnalekar · Accepted solution]

Hi,

you can do this in two ways either one you can limit the data by limitation property-->FixNumber

or Using the Rank function for the dimension.  like 

if(aggr(rank(Sum(Measure)), Dimension) <= 10, Dimension)

[nvijay5757]

Hi Abhijit,

Thank you your answer is working but 1st and last Dimension still showing 12 to 13 results

i have tried both the above but expression is only working

my Dimensions are all text(characters- Description)

[nvijay5757]

Hi Abhijit,

in my data null values are available when i apply top 10 it is showing 11 to 12 

can you please how to replace null values with 0 

[abhijitnalekar]

Hi @nvijay5757 ,

Is it possible to share the sample data?

[nvijay5757]

Hi Abhijit,

WC	WCC	WCC1	Condition
CHAS	OTHE	FRAME	FLA
CHAS		STEERIN
CHAS	OTHER		BROKEN
	OTHER	STANDARD	DOES NOT
CHAS		FRONT	FLA
CHAS	SHOCK	FRONT
CHAS	SHOC	FRONT	LOOSE
CHAS	FRONT		CHAFED
CHAS		FRONT
CHAS	SHOC	FRONT	LOOSE
	SHOC	REAR	SURFAC
CHAS	DISC		SURFAC

the sample data, some null values are available. can you please help me.

[abhijitnalekar]

Hi @nvijay5757 ,

Is Include null value is unchecked.

[nvijay5757]

Hi Abhijit,

the above option is fine. already checked that.

my conditions are 1. to display overall %  2. top 10 to display

when i uncheck the option the overall % is changing and it is showing 35% not 100%

and instead of top 10 it is showing 11 to 12 showing Sankey chart

and i applied for top 10 =if(aggr(rank(Count()), ) <10, )

and selected limitation also

all options i have tried.  help me