Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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:

Capture.PNG

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?

2 Replies
lost_rabbit
Contributor III
Contributor III

Did you find an answer to this? Please update

JuanGerardo
Partner - Specialist
Partner - Specialist

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

JG