You can try with Concat() function. like
='https://Generic_Doc_Name&Sheet=SH04&Select=LB238,' & Concat(DISTINCT Year,',')
If you want both (Year and Month) selection should pass in a single url, may be can create the bookmark (assume you are using the action in Button), then try to give Bookmark in a URL. Like
Thank you so much! The addition of the Concat statement above worked brilliantly for multiple selections in the same list box.
The bookmark idea is a good idea, but not ideal for my situation. The sheets are used as more self discovery tools that drill into the data and each week different facilities may need to be addressed and drilled into.
If there was just a way to add in 1 more List Box representing months selected into the above URL so Years and Months selected could be carried over as users navigated between sheets and books, I would be all set!
Thank you for your reply!
The formula URL above is just reflecting year(s).
Yes, there is another Dashboard, I am using document chaining, which is why I need the filter parameters to pass via URL.
There are many ways to achieve the same ,one of the easiest way is to use "Open QlikView Document" action.Steps:
1)Right click on dashboard ->New Sheet Object ->Button
2)Give a meaningful name to you button
3)Go to Actions Tab->Click Add->select action type as External ->Select Open Qlikview Document
4)Give the target QVW/dashboard name under "Document" for example test.qvw without any quotes or equal to sign.
if the target dashboard is not in the same folder ,give relative path
5)Check the Radio box Transfer State .This will transfer All the selection from one dashboard to other.
- Fields must have the same name in both documents to carry the selection from one dashboard to other
- "On Open document/sheet" triggers could modify the selections
Let me know if this works for you or not. if yes Mark the answer so that it is helpful for others
Thanks for the response, but I need to use AJAX and a URL to pass my parameters so creating a button referencing a workbook is not an option. I have already created a button to external URL that passes somewhat successfully.
&Select=LB244,' & Concat(DISTINCT Year,',')
& if(isMonthSelected=1, '&Select=LB243,' & Concat(DISTINCT Month,',') ,'')
& if(IsFacilityIDPossible=1,'&Select=LB256,'& Concat(Distinct Facility_ID,','),'')
The issue I am having now is my URL is getting too long. (See Below) I am struggling to find a way to reference the Facility_ID field within List Box 256 if no selection is made.