topic Calculated (drill-down) dimension shows expression instead of title in chart object labels in App Development

Calculated (drill-down) dimension shows expression instead of title in chart object labels

Wed, 30 Mar 2016 20:40:28 GMT

Hi there,

Looking to solve an easy one. I wanted to show a limited result set in my tables and charts, so I constrained the rows that were shown by creating a new version of an existing dimension:

Drill-Down Dimension:

=IF ( [Version 1] = 'Actual' and [Segment] = 'A', Customer )

=[CID DESC]

This dimension allows my measures to return a desired set of data without using set-analysis (a requirement for these chart objects).

Now the labels in the pivot table and charts look like this:

I haven't found a way to tell a drill-down to use it's title as the label instead of the expression. Is this Qlik Sense "as-built" behavior?

Re: Calculated (drill-down) dimension shows expression instead of title in chart object labels

lost_rabbit — Thu, 29 Apr 2021 19:43:38 GMT

Did you find an answer to this? Please update

Re: Calculated (drill-down) dimension shows expression instead of title in chart object labels

JuanGerardo — Thu, 29 Apr 2021 20:02:01 GMT

Try to use the expression as a Master Dimension, and then use the master dimension in your chart.