Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
agigliotti
Partner - Champion
Partner - Champion

Qlik Sense - drill down dimension

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

24 Replies
Anonymous
Not applicable

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
Partner - Champion
Partner - Champion
Author

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
Specialist
Specialist

Dynamic label feature in not available in Qliksense.

agigliotti
Partner - Champion
Partner - Champion
Author

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Partner - Champion
Partner - Champion
Author

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Partner - Champion
Partner - Champion
Author

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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.