Container Object to interact with input box and drill down group

[helen_pip]

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

[Gysbert_Wassenaar]

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.

[helen_pip]

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

[Gysbert_Wassenaar · Accepted solution]

see attached example.

[helen_pip]

    Thank you Gysbert