topic QlikView Container tab selections in QlikView

QlikView Container tab selections

vindhya_giri — Tue, 27 Aug 2019 18:12:24 GMT

Hello,

I have 2 container objects in my application. My requirement is:

When 'ABC CHANGE BY STATE' tab is selected in CONTAINER1, 'XYZ CHANGE BY STATE' tab should be selected in CONTAINER2. And When 'ABC CHANGE BY QUARTER' tab is selected in CONTAINER1, 'XYZ CHANGE BY QUARTER' tab should be selected in CONTAINER2.

Vice Versa - When 'XYZ CHANGE BY STATE' tab is selected in CONTAINER2, 'ABC CHANGE BY STATE' tab should be selected in CONTAINER1. And When 'XYZ CHANGE BY QUARTER' tab is selected in CONTAINER2, 'ABC CHANGE BY QUARTER' tab should be selected in CONTAINER1.

Could you please advise me on how to achieve this requirement?

Thank you very much!

Re: QlikView Container tab selections

kji — Wed, 28 Aug 2019 10:59:25 GMT

make a macro with

set container=ActiveDocument.GetSheetObject("CT01") 'change ID to your container
container.ShowSingleObject 1 'change number to which object to show

Re: QlikView Container tab selections

vindhya_giri — Wed, 28 Aug 2019 13:57:04 GMT

Hi Kji,

I tried the option you suggested but I am not able to get the result. Attached is the sample qvw. Could you please advise me on this?

Thank you very much!