topic Re: Container Object to interact with input box and drill down group in QlikView

Container Object to interact with input box and drill down group

helen_pip — Wed, 03 Aug 2016 07:18:03 GMT

Dear Qlikview User

Container Object

I have a container object which has 4 pivot tables within it

Each pivot table has the same dimension. The dimension is a group of fields I.e. Division, Care Group, Treatment Function

Input Box

I then have an input box where I am using the same dimension as the pivot tables within the container, which enables the user to make a selection and the pivot table interacts with the input box

Help with the following

I now want to revert back to the pivot tables within the container and add an extra drill down group. However I don't want this group to be visible to the end user, but I just want the functionalty to work

At the moment the addition of the extra group is expectantly showing an extra column. I would like this column to be grouped up and not visible to to the end user

Any suggestions?

Kind Regards

Helen

Re: Container Object to interact with input box and drill down group

Gysbert_Wassenaar — Wed, 03 Aug 2016 07:42:18 GMT

You want to nest a drilldown group in another group? That's possible. Add an expression for the second level group to the top level group: =$(='[' & GetCurrentField(SecondLevelGroupNameHere) & ']'). You won't have a drill up/down button though.

Re: Container Object to interact with input box and drill down group

helen_pip — Wed, 03 Aug 2016 08:04:10 GMT

Hello Gysbert

Thank you for your suggestion. I know this is common place, but could you kindly attach an example, so I can see a working example

Only if not too much trouble

Kind Regards

Helen

Re: Container Object to interact with input box and drill down group

Gysbert_Wassenaar — Wed, 03 Aug 2016 09:54:24 GMT

see attached example.

Re: Container Object to interact with input box and drill down group

helen_pip — Thu, 04 Aug 2016 09:32:17 GMT

Thank you Gysbert