Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

agigliotti
Honored Contributor II

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

Tags (1)
15 Replies
qmarache
New Contributor

Re: Qlik Sense - drill down dimension

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
Honored Contributor II

Re: Qlik Sense - drill down dimension

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
Valued Contributor

Re: Qlik Sense - drill down dimension

Dynamic label feature in not available in Qliksense.

agigliotti
Honored Contributor II

Re: Qlik Sense - drill down dimension

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.

MVP
MVP

Re: Qlik Sense - drill down dimension

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
Honored Contributor II

Re: Qlik Sense - drill down dimension

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

MVP
MVP

Re: Qlik Sense - drill down dimension

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
Honored Contributor II

Re: Qlik Sense - drill down dimension

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.

MVP
MVP

Re: Qlik Sense - drill down dimension

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.

Community Browser