topic Re: How use to getselectedcount function in sankey chart? in App Development

How use to getselectedcount function in sankey chart?

Jieun — Thu, 16 Sep 2021 09:04:22 GMT

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.

Re: How use to getselectedcount function in sankey chart?

stevejoyce — Thu, 16 Sep 2021 12:54:29 GMT

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

Re: How use to getselectedcount function in sankey chart?

Jieun — Thu, 23 Sep 2021 01:01:18 GMT

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?

Re: How use to getselectedcount function in sankey chart?

stevejoyce — Thu, 23 Sep 2021 10:34:07 GMT

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".