Drill down dimension with label expression

[José]

Hi.

I'd like to know if it's possible to have label expression in drill down dimension like in single dimension?

I'm planning to use such a feature for label translations.

Tested on Qlik Sense Enterprise, version Novermber 2021.

[anthonyj]

Hi @José,

I get around the restriction to labels by adding a condition in the Title when I use the drill down measure. 

For Example:

And in the title I added this condition:

=if(GetSelectedCount([Package Type]) > 0, 'Product SKU',
if( GetSelectedCount([Product Group]) > 0,'Package Type'
,'Product Group'))

This might help with your requirement.

Thanks

Anthony

[José]

Hi @anthonyj, 

Thank you for your reply.

Sorry, I'm a Qlik newbie so I think I didn't follow you... For what component must I set the Title?

In my case, I have a bar chart with a time dimension setup for drill down in this way: year -> month -> day.

So, I'd like to use some kind of expression - like the one you shared, to translate the labels ("Ano O.S.", "Mês O.S." and " Data O.S.") in this bar chart component.

Thank you

José

[anthonyj · Accepted solution]

Hi @José,

The label section at the bottom is set by Qlik to show the hierarchy when drilling down. That part can't be changed except for in the load script where you change the column name with an "AS" statement. But you can add a dynamic title to the chart to make it clear which level the user is looking at:

This goes under the properties panel -> General -> Title

='Sum of Sales by ' & if(GetSelectedCount([Package Type]) > 0, 'Product SKU',
if( GetSelectedCount([Product Group]) > 0,'Package Type'
,'Product Group'))

For the condition you start at the lowest grain and work your way up. So in your case:

='Sum of Sales by ' & if(GetSelectedCount([Mês O.S]) > 0, 'Data O.S',
if( GetSelectedCount([Ano O.S.]) > 0,'Mês O.S.'
,'Ano O.S.'))

I hope this will go some way to helping with your requirement.

Thanks

Anthony

[José]

Thank you @anthonyj for the detailed explanation!

This is a nice workarround.

Thank you

José