topic Re: Custom Labels For Dynamic Drill Down Dymension in App Development

Custom Labels For Dynamic Drill Down Dymension

undergrinder — Thu, 05 Nov 2015 15:55:09 GMT

Hi All!

I have to make a cyclic dimension-like solution at a table (Qlik Sense 1.1).

I have downloaded an extension (Variable Button), with I am able to make a cyclic dimension.

If I add a drill-down dimension to the table, I'll get the function as a label.

The drill down hierarchy:

level 1: if($(var)=1,'A dimension','B dimension')

level 2: if($(var)=1,'Aa dimension','Bb dimension')

The label become e.g. : if($(var)=1,'A dimension','B dimension').

As far as I know there isn't solution for the mentioned problem, I'm curios do you suggest any workaround for cyclic dimension in Qlik Sense (as far I didn't find any solution, that fits).

Thank you!

Re: Custom Labels For Dynamic Drill Down Dymension

ogster1974 — Thu, 05 Nov 2015 22:53:57 GMT

‌drill downs in sense are created through masteritems dimensions unfortunately we cannot use master items expressions so the combination of cyclical and drill downfunctionality is out of reach. I'd suggest using the method your using with the 4 options available to the user rather than filter drill downs.

I think you have the way to do this covered but I'll add a link to how I've down it in the past

Makes Sense to go round in circles

Re: Custom Labels For Dynamic Drill Down Dymension

undergrinder — Mon, 09 Nov 2015 09:12:49 GMT

Hi Andy!

The linked documennt is very nice and useful, but doesn't cover my problem.

The main problem is, like the attached qvf at Makes Sense to go round in circles, filter works fine, altough the filter band shows the formula instead of label.

Re: Custom Labels For Dynamic Drill Down Dymension

ogster1974 — Mon, 09 Nov 2015 15:21:31 GMT

The filter bar will always show the formula. this is by design. The filter bar displays filters applied to the underlying data model not a specific chart. For that reason your chart label will not show in the filter bar as this would be confusing if for example you named dimensions, measures differently in different charts. How would a user know which chart the filter was applied from? and as it filtered the model as a whole would they care?

Re: Custom Labels For Dynamic Drill Down Dymension

undergrinder — Tue, 10 Nov 2015 10:32:03 GMT

OK, I understand, but I think it is unacceptable from the client side. They only want to see fancy labels instead of functions.

Thank you for the information!

Re: Custom Labels For Dynamic Drill Down Dymension

vadimtsushko — Sun, 17 Jan 2016 13:59:35 GMT

Andy Weir написал(а):

The filter bar will always show the formula. this is by design. The filter bar displays filters applied to the underlying data model not a specific chart. For that reason your chart label will not show in the filter bar as this would be confusing if for example you named dimensions, measures differently in different charts. How would a user know which chart the filter was applied from? and as it filtered the model as a whole would they care?

Hi, Andy.

Actually, I believe that with minor tweak in the formula for cyclic dimension in your sample application we can get result required by @undergrinder

For this I changed formula from:

Pick(Match($(vSalesView),1,2,3),'Company','Product','Month')

=$(=Pick(Match($(vSalesView),1,2,3),'Company','Product','Month'))

to:

=$(=Pick(Match($(vSalesView),1,2,3),'Company','Product','Month'))

BTW, I used similar technic here: Emulating cyclic dimension group in Qlik Sense Desktop

Re: Custom Labels For Dynamic Drill Down Dymension

ogster1974 — Sun, 17 Jan 2016 22:05:15 GMT

‌nice tweak I'll update my document accordingly?

Re: Custom Labels For Dynamic Drill Down Dymension

vadimtsushko — Mon, 18 Jan 2016 03:05:25 GMT

Yes, of course.

Re: Custom Labels For Dynamic Drill Down Dymension

undergrinder — Mon, 18 Jan 2016 12:04:01 GMT

Hi Vadim,

The cycleic dimension is known by me, this is not exactly, what I want, but I'll try the =$(=...) formula for drill down dimension.

Re: Custom Labels For Dynamic Drill Down Dymension

vadimtsushko — Tue, 19 Jan 2016 04:13:22 GMT

Hi, undergrinder.

I do not know your actual requirements, this tweak just solves the problem that you wrote about:

Hi Andy!

The linked documennt is very nice and useful, but doesn't cover my problem.

The main problem is, like the attached qvf at Makes Sense to go round in circles, filter works fine, altough the filter band shows the formula instead of label.

G.

Re: Custom Labels For Dynamic Drill Down Dymension

la259031 — Mon, 23 Jul 2018 18:00:31 GMT

Hi,

Create Single Dimension in master item section, using below functions(one for level 1 and one for level 2) and in label expression give name as level 1 & level 2 OR name of your choice. It will reflect in drill down group too.

level 1: if($(var)=1,'A dimension','B dimension')

level 2: if($(var)=1,'Aa dimension','Bb dimension')