Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
Egon
Contributor

Drilldown Change Legend Title

Dear reader,

I've created a drill-down dimension on my graphs, but now the title of the legend changes to how these fields are named in the load editor.  Is there a way to change the naming of the legend title, while maintaining the dynamic of changing titles when clicking down to a lower level?

More concrete,

My dimensions are %Division, %Team and %System, as they are named in the load editor. I'd prefer the legend titles to just be Division, Team, and System. Is it possible to do this without changing the names of the fields in the load editor?

Cheers!

 

Labels (2)
1 Reply
stevedark
Partner Ambassador/MVP

Hi @Egon 

The quick answer is no. You need to name the fields how you want them to be in the drill down.

A way around this is to create a calculated dimension that calculates which dimension is used, something like:

=if(count(distinct %Division) > 1, %Division, if(count(distinct %Team) > 1, %Team, %System))

You can then do similar for the label:

=if(count(distinct %Division) > 1, 'Division', if(count(distinct %Team) > 1, 'Team', 'System'))

If you can get that working (and there could be errors as I have typed it straight into this box without testing) then it emulates a drill down without actually being a drill down.

You might also want to take a look at this post, which shows another way of having dimensions selected:
https://www.quickintelligence.co.uk/instant-qlik-sense-application/

Hope that helps.

Steve