topic Re: Sheet selection controlled by a listbox and Text Object (Button) in Water Cooler

Sheet selection controlled by a listbox and Text Object (Button)

zwyne — Mon, 07 Jan 2019 09:40:10 GMT

Hello everyone,

PFA,

On the attached app and in particular "Landing Page" sheet. When I select any of the entries in the Dimensions 'Country' or BU and then click "Select CA" or "Select IR" then based on the selections from both listbox and text object should reflect on the charts in CA or IR. Is it also possible to hide either one of the sheets based on the selection on Text object.

Regards

Re: Sheet selection controlled by a listbox and Text Object (Button)

kamalqlik — Mon, 07 Jan 2019 11:38:45 GMT

Hi,

Please use attached QVW with solution.

1) When Nothing will be selected you will get:

2) When Country and select CA is selected you will get output:

Same in case of BU

3) When Country and IR is elected you will get output as:

Use the Clear button to get into your default view ie when no selection is made.

Regards

Kamal

Re: Sheet selection controlled by a listbox and Text Object (Button)

zwyne — Mon, 07 Jan 2019 12:00:26 GMT

Thank you Kamal. It's exactly what I was looking for.