topic Dynamic Chart Title in QlikView

Dynamic Chart Title

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

Hi Everyone,

Can any one please help me on dynamic title change.

I have a field named Region contains records like Europe, Asia, North America, Middle East etc...

In the chart title I have to shown Total Activities by Region as chart title. But now if i select any of those region then i want to hide Total Activities by Region and show selected region.

Can anyone help me on this.

Thanks in advance.

@rubenmarin @hic

Re: Dynamic Chart Title

hic — Mon, 24 Aug 2020 16:36:18 GMT

=If(Count(distinct Region)=1,'Activities in ' & Region,'Total Activities by Region')

Re: Dynamic Chart Title

TheBeginner — Mon, 24 Aug 2020 16:38:31 GMT

Thank you so much @hic it worked perfectly alright.