How to know the level (field) shown in a drill-down dimension

[dvilloldo]

Hi.

We are using a drill-down dimension (year - month - day - hour) in a bar chart and in a box plot chart.

We want to know the level (field) of the drill-down dimension shown in any moment.

The reason is because we need to calculate the average in any bar (aggregate by the shown level) and show a subtitle in the chart about the information the user can see. For example: "The data shown is from february 2021".

We already tried using evaluation of any of the fields included in the drill-down dimension using GetSelectedCount(field) and IsNull(field), but this doesn't work right because the user can filter any dates and the drill-down level can change without having any of the fields in the drill-down dimension selected. 

Any help, please?

Thank you and greetings from Spain.

[Or]

Try using GetObjectDimension()

[dvilloldo]

Thank you, Or, but I think this is not valid for us.

GetObjectDImension() is only valid at the chart row level, and we need to know out of row level: for aggregation at bar level and for information in the subtitle of the bar chart.

Any other idea?

[Or]

In that case, I don't know of any way to achieve this other than checking each level of the drill-down to see whether it contains a single value using e.g. NOT isnull(Only(Field)) or Count(distinct Field)=1. Unfortunately, Qlik Sense does not have QV's GetCurrentField() function.