- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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