Qlik Community

Qlik Sense App Development

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

Not applicable

Referring to drill downs

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

3 Replies
Vegar
Valued Contributor

Re: Referring to drill downs

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

Not applicable

Re: Referring to drill downs

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?

Vegar
Valued Contributor

Re: Referring to drill downs

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

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/ge...

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.

Community Browser