Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am working on generating URL that will open the relevant sheet with a specific set of parameters.
When it comes to selecting a Sheet or List Box values, I have no problem using the following patterns:
www.domain.com/QvAJAXZfc/opendoc.htm?document=Report.qvw&host=hostname&sheet=SH1&select=LB12,France
BUT, when I try to pass URL params to List Boxes (LB) that are contained in a Container (CT), I can't manage to make it work.
For an example, I have a Container (CT12) that includes 3 ListBox slicers (61,92,93). How can I pass their selection
select=LB61,Value and select=61,Value didn't work
Try to create two listboxes. One in the container as mentioned and one out of the container.
Hide the one out of the container using layout > Show > conditional (Either use a variable or 1=2 to hide)
then use the ID of the hidden listbox to pass the parameter?