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

[zwyne]

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

BZ

[kamalqlik · Accepted solution]

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

[zwyne]

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