Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Jieun
Contributor II
Contributor II

How use to getselectedcount function in sankey chart?

Hello! 

I'am using Qlik sense and sankey chart. 

The chart I use expresses too much data, so the readability of the information is very low.

Therefore, I want to use the function used in other charts, but I haven't found a way to use it in the Sankey chart.

 

Using the GetSelectedcount function, I want to activate the Sankey chart only when data that satisfies the condition is selected.

For example, if you choose one year and one country, show the Sankey chart, and I hope that it will not be activated before then.

 

Could you help me to solve this problem?

Thank you in advance. 

3 Replies
stevejoyce
Specialist II
Specialist II

In the Sankey Chart properties > Date Handling, enter your formula in Calculation condition.

You probably want GetPossibleCount instead of GetSelectedCount, this way if other selections result in limited values in a field possiblecount will pick this up.  You are probably more interested in result of data rather then what the user actually selected in a specific field. But you can update below to getselectedcount() if you want

=GetPossibleCount( [Country] ) = 1 and GetPossibleCount( [Year] ) = 1

stevejoyce_2-1631796861410.png

 

 

Jieun
Contributor II
Contributor II
Author

Thank you for your reply. 

Unfortunately, I couldn't find data handling menu.

 

I attached sankey menu I used. 

 

Where can I find menu for function?

sankey menu.JPG

stevejoyce
Specialist II
Specialist II

Sorry looks like i was referring to the vizlib sankey.

Try making your Sankey chart a master visualization and using the Container object, add your master viz to the container.  There you can set "Show condition".