topic dynamic title for chart in QlikView

dynamic title for chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a bar chart which lists the top 10 destinations in descending order. The chat title is "Top 10 Destinations". If user selects the top 4 ( or any number of destinations) by selecting on the chart, i want to change the title to reflect the number of destinations selected. eg. Top 4 Destinations etc.

How can i get the number of destinations by taking user's selection on the chart?

Re: dynamic title for chart

danansell42 — Mon, 18 Dec 2017 12:14:33 GMT

=if(getselectedcount(Destinations)<10,'Top '&getselectedcount(Destinations)&' Destinations','Top 10 Destinations)

Re: dynamic title for chart

Anil_Babu_Samineni — Mon, 18 Dec 2017 12:16:05 GMT

May be this?

='Top ' & Count(Destinations) & ' Destinations'

Re: dynamic title for chart

Anonymous — Mon, 18 Dec 2017 13:32:10 GMT

1780137d wrote:

Hi,

I have a bar chart which lists the top 10 destinations in descending order. The chat title is "Top 10 Destinations". If user selects the top 4 ( or any number of destinations) by selecting on the chart, i want to change the title to reflect the number of destinations selected. eg. Top 4 Destinations etc.

How can i get the number of destinations by taking user's selection on the chart?

To elaborate further...

When the group of Top 4 destinations is selected ( by circling the bars in the chart), title becomes

Re: dynamic title for chart

Peter_Cammaert — Mon, 18 Dec 2017 14:31:32 GMT

Or maybe limit the upper boundary (because it is highly probable that the Dimension Limits tab has been activated or set analysis reduces the max number of dimension values):

='Top ' & RangeMin(Count(DISTINCT Destinations), 10) & ' Destinations'

Re: dynamic title for chart

Anonymous — Mon, 18 Dec 2017 17:02:27 GMT

Hi Daniel,

Thanks for the tip. It works for me with the getselectedcount()

Re: dynamic title for chart

danansell42 — Mon, 18 Dec 2017 17:04:58 GMT

my original solution was slightly wrong as if no selections were made then it would say Top 0 destinations.

I have fixed this now

=if(getselectedcount(destination)=0,'Top 10 Destinations',
if(getselectedcount(destination)<10,'Top '&getselectedcount(destination)&' Destinations','Top 10 Destinations'))

I've just tested and based on what you are asking for this works fine

Re: dynamic title for chart

Anonymous — Tue, 19 Dec 2017 09:26:16 GMT

Hi Daniel,

Thanks for the quality check. It's working well with your suggestion.

Re: dynamic title for chart

Anonymous — Wed, 20 Dec 2017 00:19:01 GMT

Hi Peter,

Thank you for the neat solution. learnt something today.