Qlik Sense - drill down dimension

[agigliotti]

Hello,

mto‌

I'm noting it's not possible to apply a dynamic label for each field in drill-down master item dimension.

I'm using Qlik Sense Server February 2018 patch 1 version.

I guess it's a missing feature!

How can I achieve it?

Many Thanks.

BR

Andrea

[Anonymous]

Hi Andrea,

Have you look on stevedark‌ article ?

https://www.quickintelligence.co.uk/qlik-sense-cycle-group/

It works like a charm on my apps

Quentin

[agigliotti]

here i'm not talking about a cyclic group but a drill-down dimension and specifically that we are not able to use a dynamic text label for each field used in a master item drill-down dimension.

I hope now it's clear.

stevedark‌

[passionate]

Dynamic label feature in not available in Qliksense.

[agigliotti]

yes it is but not in the master item section for drill-down dimension where the label expression is missing.

I hope to see this feature available in next April 2018 version.

[stevedark]

Hi Andrea,

You should be able to build a drill down dimension by coding for it.  You can also use the dynamic label to give the correct name on the dimension.

I've not tried this in Sense, but something like this should work;

=if(GetPossibleCount(County) = 1, Town,

   if(GetPossibleCount(Country) = 1, County,

   if(GetPossibleCount(Continent) = 1, Country,

   Continent)))

You can then use very similar for the label, just encapsulate the field names in quotes to make them labels:

=if(GetPossibleCount(County) = 1, 'Town',

   if(GetPossibleCount(Country) = 1, 'County',

   if(GetPossibleCount(Continent) = 1, 'Country',

   'Continent')))

You can also change the GetPossibleCount variable so that you show Towns if you have 5 or fewer Counties selected.  You can see this technique in this QlikView app that I have shared online:

QlikView App: Dynamic Date Dimension - With Hours

The reason I have not done this in Sense yet is I am not a fan of drill down dimensions, as stuff changes without the user explicitly requesting it to - I would go for allowing the user to pick which dimension they want every time.

Hope that helps.

Steve

[agigliotti]

thanks for your answer.

anyway in my scenario where I'm developing a multilanguage app with Qlik Sense your solution can't be applied.

specifically I'm using a function like =Minstring( {< pk = {'valueofpk'} >} $(vLanguage) ) to dinamically traslate all the labels based on the language choosen by the user.

For Master Items drill dimensions I can't do the same because of missing feature.

Best Regards

Andrea

[stevedark]

Hi Andrea,

You can use the translation function within the label expression of the dimension, as I put above.  Just replace the label in single quotes with your translation code.  I don't quite follow your translate code, but you would have something like:

=if(GetPossibleCount(County) = 1, MinString({<Lang={'$(vLanguage'},Label={'Town'}>}TransLabel),

   if(GetPossibleCount(Country) = 1, MinString({<Lang={'$(vLanguage'},Label={''County'}>}TransLabel),

   if(GetPossibleCount(Continent) = 1, MinString({<Lang={'$(vLanguage'},Label={''Country'}>}TransLabel),

   MinString({<Lang={'$(vLanguage'},Label={''Continent'}>}TransLabel))))

[agigliotti]

i don't have the possibility to insert that statement (if condition) in master item drill-down dimension because there is not the label expression text box as is in single dimension.

[stevedark]

The whole point of this approach is that it doesn't use a Sense drill down dimension.  It uses a standard Sense dimension (without drill down) in which you then create your own pseudo drill down in code.  This means the dynamic label is therefore available.