topic Can a drill down group be a variable in QlikView

Can a drill down group be a variable

helen_pip — Wed, 03 Aug 2016 08:53:28 GMT

Dear Qlikview user

I have a variable called vField_OPD and this variable contains 3 field names I.e. Division, Care_Group, Function

I would like to use this variable as a drill down group in my pivot table

I created a drill down group called Test and used $(vField_OPD) as my Used Fields

From the front end, Division shows as my dimension, but I am unable to drill through

Is it possible to use a variable as my drill down group?

Kind Regards

Helen

Re: Can a drill down group be a variable

sunny_talwar — Wed, 03 Aug 2016 08:56:05 GMT

I think you can create three variables:

vField_OPD1

vField_OPD2

vField_OPD3

and then instead of assigning all three dimensions to one variable, assign one each to the above three.

Then use them as three fields using dollar sign expansion

$(=vField_OPD1)

$(=vField_OPD2)

$(=vField_OPD3)

Re: Can a drill down group be a variable

helen_pip — Wed, 03 Aug 2016 09:14:19 GMT

Hello SunnyT

Thank you for your suggestion.

I have the drill down as you have suggested working with the 3 variables. I created a group called Test and within Test there are the 3 variables

My next quest it to have an input box where the end user can either drill down within the pivot table (Solved) or use the input box as a list box and choose one of the 3 categories I.e. Division, Care_Group, Treatment_Function

Can you kindly suggest any way I can get the pivot table to interact with the input box using the Test field I created?

Re: Can a drill down group be a variable

sunny_talwar — Wed, 03 Aug 2016 09:19:16 GMT

So you can use triggers to assign the three values that have been selected into the three variables

variable 1 trigger can have the following search string:

SubField(Concat(DISTINCT ListBoxFieldName, ','), ',', 1)

variable 2 trigger

SubField(Concat(DISTINCT ListBoxFieldName, ','), ',', 2)

variable 3 trigger

SubField(Concat(DISTINCT ListBoxFieldName, ','), ',', 3)

Everything else can stay the same, right?

Re: Can a drill down group be a variable

helen_pip — Wed, 03 Aug 2016 09:53:07 GMT

Hello SunnyT

Thank you for your suggestion. I am not sure I follow the logic. Where would I place these triggers? In the input box?

Kind Regards

Helen

Re: Can a drill down group be a variable

sunny_talwar — Wed, 03 Aug 2016 09:55:57 GMT

These triggers will be within the document properties -> Triggers Tab -> Field Event Trigger

I don't think you will need a input box here. All you would need is a list box and user making selection to it.

Re: Can a drill down group be a variable

helen_pip — Thu, 04 Aug 2016 09:33:07 GMT

Thank you SunnyT

This is working for me