topic Re: Qlik Sense - drill down dimension in App Development

Qlik Sense - drill down dimension

agigliotti — Tue, 10 Apr 2018 13:18:01 GMT

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.

Andrea

Re: Qlik Sense - drill down dimension

Anonymous — Tue, 10 Apr 2018 14:18:50 GMT

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

Re: Qlik Sense - drill down dimension

agigliotti — Tue, 10 Apr 2018 15:12:24 GMT

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‌

Re: Qlik Sense - drill down dimension

passionate — Tue, 10 Apr 2018 15:55:42 GMT

Dynamic label feature in not available in Qliksense.

Re: Qlik Sense - drill down dimension

agigliotti — Wed, 11 Apr 2018 08:36:02 GMT

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.

Re: Qlik Sense - drill down dimension

stevedark — Wed, 11 Apr 2018 18:44:04 GMT

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

Re: Qlik Sense - drill down dimension

agigliotti — Wed, 18 Apr 2018 09:41:32 GMT

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

Re: Qlik Sense - drill down dimension

stevedark — Wed, 18 Apr 2018 10:35:23 GMT

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

Re: Qlik Sense - drill down dimension

agigliotti — Wed, 18 Apr 2018 10:47:28 GMT

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.

Re: Qlik Sense - drill down dimension

stevedark — Wed, 18 Apr 2018 10:52:08 GMT

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.

Re: Qlik Sense - drill down dimension

agigliotti — Wed, 18 Apr 2018 11:02:49 GMT

I have 4 fields within a drill down dimension, in which way I can traslate, using the code above, the four fields label ?

Re: Qlik Sense - drill down dimension

stevedark — Thu, 19 Apr 2018 10:02:46 GMT

Rather than creating a Drill Down dimension create a standard dimension, and then use the code I have posted above. You will need to change the field names to match your own.

Re: Qlik Sense - drill down dimension

agigliotti — Thu, 19 Apr 2018 10:06:40 GMT

if I well undertstood I need to create a listbox with all dimension field names to check which dimension has been choosen by the user.

It's a sort of cyclic group rather than a drill-down dimensions group.

is it right ?

Re: Qlik Sense - drill down dimension

stevedark — Thu, 19 Apr 2018 10:20:46 GMT

Not quite. No list box is required to select the dimension, it will happen automatically based on the number of possible values in each field.

Re: Qlik Sense - drill down dimension

agigliotti — Thu, 19 Apr 2018 10:24:23 GMT

Steve, i'll try and i'll let you know.

Re: Qlik Sense - drill down dimension

agigliotti — Tue, 24 Apr 2018 08:14:21 GMT

Hi Steve,

Finally yesterday I had time to try your suggestion on how to apply a workaround because of missing feature.

When I select a value on first dimension (ex. continent), QIX make selections also on all other dimensions fields (ex. country, city, etc...) and this is unwanted.

Using instead the drill-down dimension it doesn't occurs.

Definitely I think it's not a true workaround.

I really hope Qlik will implement this feature in next releases.

Best regards

Andrea

Re: Qlik Sense - drill down dimension

LCauch — Mon, 12 Oct 2020 16:04:17 GMT

Hi @agigliotti , @stevedark

Any news about this feature ? I am stuck as well on a similar problem. I tried to use variable instead of formula but it is not working as a variable return a null value if there is more than 1 possible value (Months for example).

Thanks,

Leo

Re: Qlik Sense - drill down dimension

stevedark — Mon, 12 Oct 2020 18:57:49 GMT

Hi @LCauch

It sounds like you may be using the dimension code in a measure rather than a dimension?

The original question was related to the fact that there was no drill down dimension in Sense, something which has now been available for quite a few versions. Just create a master dimension and then add a number of hierarchical fields to the master dimension. This can then be used on any chart and should drill correctly.

There is still an issue, even at Sept 2020, that you can not get a label from the drill down dimension. For this you need to code it. My code from way back when still works for this, in the dynamic label field:

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

Hopefull that gives you what you require?

There is a link in one of my earlier responses related to when you want to drill when there is not only one possible option. You may also like to take a look here, where I have an app you can download and use with many selectable dimensions:

https://www.quickintelligence.co.uk/isa/

Steve

Re: Qlik Sense - drill down dimension

LCauch — Wed, 14 Oct 2020 13:10:31 GMT

Hi @stevedark ,

Thanks for your reply. Yeah, I regret the fact that we can't customize label in a drilldown master item...

Are you using your code with a master dimension ? So my formula will be something like:

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

And my label:

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

is that right ? This solution works but when I filter on a dimension say Country using the chart, I also filter on County and Town. Can be confusing to select 1 dimension and have 3 filtered dimension. Is there a way to avoid this behavior ?

Also you're using GetPossibleCount(), why this one instead of GetSelectedCount() ?

Thanks,

Leo

Re: Qlik Sense - drill down dimension

stevedark — Wed, 14 Oct 2020 14:30:42 GMT

Hi @LCauch

If you choose to use a master dimension with a drill down (i.e. multiple fields in the dimension) the code without the quotations is redundant. The master dimension does this for you.

Alternately, you could create a 'normal' master dimension and use the code without the quotes in the master dimension expression.

The code is designed to emulate how Qlik drill down dimensions work in both QlikView and Sense. If only a single dimension value is possible, due to selections on any field then the drill will take place.

You can make it more user dependent by using GetSelectedCount, so only a selection made by the user on the right field will cause the drill to happen (you will have to use the expression code in the master dimension to go this route).

By coding the drill yourself you can do things which are not possible using the default drill functionality. If you take dates, for example, if you use a drill you will always see days if a single month is selected. But, if you select five dates spanning the end of a month (e.g. 28th to the 2nd) you will get only two bars, one for each month. By coding your own you can say if the number of possible dates is greater than X show by month, otherwise show by day.

Personally, I really don't like drill dimensions, as they often cause things to change on a dashboard without the user being fully aware of why. I will almost always opt for a drop down allowing users to select a field, or a number of buttons to set the dimension.

Sense now allows Alternative Dimensions, so the user can pick that way, but it's not possible to set chart titles etc. correctly when Alternative Dimensions are used as you can not pick up what the current dimension is in code.

Hope that all makes sense?

Steve