Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try using GetObjectDimension()
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?
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.