Passing Parameters Dynamically In URL From Selected Filters

[kwarren1]

I would like MULTIPLE user selected filters to get passed to the actual URL. My current work project requires the selected filters for Year and Month.

In the example below, I can write to have 1 selected year OR 1 selected month.

My two issues are:

(1) How can I get the URL to take year and month considerations in the same URL?

(2) How can I get the URL to dynamically reflect the List Box (LB) selections (multiple years and/months) from the user to be passed through the URL?

='https://Generic_Doc_Name&Sheet=SH04&Select=LB238,' & Max(Year)

='https://Generic_Doc_Name&Sheet=SH04&Select=LB237,' & Max(Month)

[settu_periasamy]

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

'https://Generic_Doc_Name&Bookmark=Document\BM01'

Passing Parameters in a URL and Document Chaining

[Anonymous]

Hey Kevin,

what is this actual URL ?

Kevin Warren wrote:

I would like MULTIPLE user selected filters to get passed to the actual URL.

,is this another Dashboard(If yes, you can use Document chaining) or is it some website?

[kwarren1]

Thank you for your reply!

='https://devqvs.bedashboard.com/QvAJAXZfc/opendoc.htm?document=OST%20PART%202%20FINAL.qvw&host=QVS%40...,' & Concat(DISTINCT Year,',')

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.

[kwarren1]

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!

[Anonymous]

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.

Note:

• 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

[kwarren1]

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.

='https://devqvs.bedashboard.com/QvAJAXZfc/opendoc.htm?document=OST%20PART%202%20FINAL.qvw&host=QVS%40...

&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.

https://devqvs.bedashboard.com/QvAJAXZfc/opendoc.htm?document=OST%20PART%202%20FINAL.qvw&host=QVS%40...

&Select=LB244,2015

&Select=LB243,Sep

&Select=LB256,22768,22769,22771,22773,22775,22777,22778,22779,22780,22781,22782,22783,22784,22785,22786,22787,22788,22790,22792,22793,22795,22796,22797,22798,22800,22801,22802,22803,22805,22806,22807,22809,22810,22811,22812,22813,22816,22818,22819,22820,22821,22822,22823,22824,22825,22826,22827,22828,22829,22830,22832,22835,22836,22837,22839,22840,22842,22843,22846,22848,22849,22850,22852,22853,22854,22855,22856,22858,22860,22861,22863,22865,22867,22869,22870,22871,22872,22874,22875,22876,22877,22878,22879,22880,22881,22884,22885,22887,22888,22890,22891,22893,22896,22897,22898,22899,22900,22902,22903,22904,22905,22906,22907,22909,22910,22911,22912,22913,22914,22915,22918,22919,22920,22921,22926,22928,22929,22930,22932,22933,22934,22936,22938,22939,22940,22942,22944,22945,22946,22947,22948,22949,22951,22952,22953,22955,22956,22957,22960,22961,22962,22963,22964,22965,22966,22967,22968,22969,22970,22971,22972,22973,22974,22975,22976,22977,22978,22979,22982,22983,22987,22988,22989,22990,22991,22992,22993,22994,22996,22997,22998,22999,23002,23004,23006,23008,23009,23010,23011,23012,23013,23014,23016,23018,23019,23020,23021,23022,23023,23024,23025,23026,23027,23028,23030,23031,23032,23033,23034,23035,23036,23037,23038,23039,23040,23041,23069,23073,23083,23084,23085,23086,23087,23088,23089,23101,23102,23103,23106,23107,23110,23111,23112,23113,23114,23115,23116,23117,23118,23119,23121,23123,23124,23125,23126,23127,23128,23129,23130,23131,23133