topic Re: Referring to drill downs in App Development

Referring to drill downs

Fri, 02 Dec 2016 18:13:17 GMT

Hi, I was wondering if there was a way to refer to the drill downs as a dimension. I have an extension I am using that allows you to change the dimensions of a chart, and I understand how to for the actual fields in my code, but I want to be able to refer to a drill down.

As an example, this is using 3 fields that are in my data.

Pick(Match($(vMTKView), 1, 2, 3), Working_Atty, Billing_Atty, Originating_Atty)

Thank you!!

Re: Referring to drill downs

Vegar — Fri, 02 Dec 2016 18:58:32 GMT

I'm not really sure what you are trying to accomplish, but The getcurrentfield (groupname) should do the trick for you.

Re: Referring to drill downs

Fri, 02 Dec 2016 20:02:14 GMT

So Working_Atty, Billing_Atty and Originating_Atty are all fields in my data already.

I want to be able to replace them with drills. So instead of Working_Atty, I want something that will drill from department, to section, to title, to working attorney. But how to a refer to the in a formula? is it even possible?

Re: Referring to drill downs

Vegar — Sat, 10 Dec 2016 19:53:53 GMT

Do I understand you correctly that you have managed to create a drill down dimension in Qlik Sense? If not then take a look at https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/Dimensions/create-drill-down-dimension.htm

To refer to the current dimension in a drill down use the getcurrentfield() https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/FieldFunctions/getcurrentfield.htm?_g…

In an expression you can refer to it using $ expansion.

Eg: count([$(=getcurrentfield(YourGroupDimension)]) will return the count on the active dimension Working_Atty, Billing_Atty or Originating_Atty.