how to change the chart title when drll down to other dimenstion?

[daisy1438]

Hi

I have country and region fields and creating the drill down using those fields. And initial my chart title is "ID Count by region".

once user select any region the chart show country wise.

my requirement is when chart drill down region to country than automatically change the my chart title like "ID count by country".

it is possible to do this.

Thanks.

[undergrinder]

Hi Daisy,

You can control the title by the getselectedcount([field]) function in the title.

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/ChartFunctions/FieldFunctions/gets...

Similar logic:

=If(getselectedcount([upperLevel]) = 0 or getselectedcount([upperLevel]) > 1, 'Title 1','Title 2')

G.

[niclaz79]

Hi,

You can use

=GetCurrentField(DrilldownName)

Where you place the name of your drill down group. It will show as incorrect but will give you the name of the field that is currently being shown by the group. And you can change the label of the levels in the group editor.

[daisy1438]

Hi Gaor

I am trying to above expressions. But it is not  showing properly.

I am using below exp

=If(getselectedcount([Issue Location]) = 0 or getselectedcount([Issue Location])<1 ,'Issues by Geography','Issues by Region').

Actually I have two fields 1)IssueRegion  2)IssueLocation

Using both fields creating drill down and initial chart showing based on region once user click any region than chart showing the based on location(under the regions what are the location available).

By default chart showing the region wise and chart title "by region".

my requirement is when chart showing based on location and change the Chart Title "by Location"

Thanks.

[undergrinder]

you should handle all case in title.

If you have two level Region>Location then

if( getselectedcount([Issue Region]) = 0 and getselectedcount([Issue location]) = 0  /*nothing selected*/

or getselectedcount([Issue Region]) > 1  /*multiple region */, 'Region level','Location level')

there are maybe cases that this example don't handle, but if you get the logic beneath them, you can handle all cases.

G.