Qlik Community

App Development

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

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MVP
MVP

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Not applicable
Author

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

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.

Plees ekskuse my Swenglish and or Norweglish spelling misstakes