Suggest an Idea

[JohannEls]

Hi,
It would really help if we could give each field in a Dimension Drill-Down its own label or alternatively have the option to use Dimension Labels instead of fields when creating a Dimension Drill-down.
Thanks

[amarkow]

So I actually submitted a support ticket on this very thing,.  You can technically use dimension labels if you configure them as a single-dimension first.  It will then carry forward the labeling (or if you use island tables you can select labels based on active "dimensions")

[jasmina_karcic]

Hello,

This option doesn't work in my case, for some reason.

I writed:

IF(GetSelectedCount(Dim1)>=1, 'Dim2',
if( GetSelectedCount(Dim1)>=1 AND GetSelectedCount(Dim2)>=1, 'Dim3',
if( GetSelectedCount(Dim1)>=1 AND GetSelectedCount(Dim2)>=1 and GetSelectedCount(Dim3)>=1, 'Dim4',
'Dim1'))).

It just is showing to me Dim1 and Dim2. Other not.

Also, the same situation if is written:

IF(GetSelectedCount(Dim1)>=1, 'Dim2',
if( GetSelectedCount(Dim2)>=1, 'Dim3',
if(  GetSelectedCount(Dim3)>=1, 'Dim4',
'Dim1'))).

Any suggestion how to make it?

Thanks 

Jasmina

[amarkow]

@jasmina_karcic would you be able to submit an example?  Also, what version of Qlik Sense are you using?

[jasmina_karcic]

Enterprise August 2022,

I don't have example., data are real. Maybe can help you information that all these dimensions are from one table. Not from others.

Example can be like:

Dim1- City

Dim2- Street

Dim3- Address

Dim4- Someone's name.

This is a regular direction of data...:/

[Faris]

I get the same results as Jasmina. The labels don't change after the second dimension.

[mohammed_ahmed]

@JohannEls @Faris @jasmina_karcic @amarkow @Ian_Crosland 

You can still achieve it, you just have to write your expression like this :

if( GetSelectedCount(Dim1)>=1 AND GetSelectedCount(Dim2)>=1 and GetSelectedCount(Dim3)>=1, 'Dim4',

if( GetSelectedCount(Dim1)>=1 AND GetSelectedCount(Dim2)>=1, 'Dim3',

IF(GetSelectedCount(Dim1)>=1, 'Dim2',
'Dim1')))

If it solves your query , don't forget to mark it as "Correct" . 🙂

Thanks 

Mohammed

[carlcimino]

What @mohammed_ahmed wrote works for me but wish the Drill Dimension would take care of this.  It seems like unnecessary development and administrative overhead.

[Meghann_MacDonald]

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.