topic Re: How to know the level (field) shown in a drill-down dimension in App Development

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

dvilloldo — Wed, 30 Mar 2022 08:01:52 GMT

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.

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

Or — Wed, 30 Mar 2022 13:27:14 GMT

Try using GetObjectDimension()

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

dvilloldo — Wed, 30 Mar 2022 15:11:50 GMT

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?

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

Or — Wed, 30 Mar 2022 19:18:36 GMT

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.