Dynamic title for Drill-down groups in Qlik Sense Cloud

[herard_bertrand]

Hello,

I need to display the name of the active dimension in a bar chart title while using a drill-down group (NOT a cyclic group).

I’ve tried using standard group functions, but they don't seem to behave the same way with hierarchical groups as they do with cyclic ones. Is there a specific expression or workaround in Qlik Cloud to identify which level of the hierarchy is currently active?

Thanks in advance!

[rubenmarin]

Hi, inside the chart you could use GetObjectDimension() to retrieve the dimension used, but the tile it's outside the chart.

I don't know if ther is a better way but as a workaround you can check the number of possible values in each dimension, the hierarchy will show the first dimension with more than 1 possible values, in example, for a hierarchy of 4 fields:

If(GetPossibleValues(Dim1Field)=1
  ,If(GetPossibleValues(Dim2Field)=1
    ,If(GetPossibleValues(Dim3Field)=1
      ,'Dim4' // last dimension, no need to check
      ,'Dim3')
    ,'Dim2')
  ,'Dim1')

[herard_bertrand]

Hello, thanks for your workaround idea,

I think it works in QlikView but not in Qlik Sense : In Qlik Sense, the user needs to validate his selection, so for example, if the user select only one value in Dim1Field in your example, the chart will display every Dim1Field values with emphasize on the selected Dim1Field value, but the title will already displays 'Dim2' while Dim2 is not displayed yet. It's just after the user select the "validate/check" button that the display is OK 

is there any way to detect that a select is not yet validate in an expression ? 

Regards

[rubenmarin]

Hi, my example was tested on Sense but you're right, as the confirmation button appears just over the title I didn't see it was changing before to apply the selections, I tested it as an expression, and in the expression it only changes when the selctions are applied, which make me believe it was working.

I tried different options (count distinct, using variables...) but all of them changes the title before the selection is confirmed.

[herard_bertrand]

Hello,

I'm facing the same issue. The only workaround I've found is to enable the dimension title within the legend. However, this seems to force the display of all legend items, which takes up too much space in my specific use case—I only need the title itself.

I'm quite surprised by this missing feature, especially since this functionality exists for cyclic groups. Has anyone found a more "space-efficient" way to show only the active dimension title?

Thanks