Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Passing Parameters Via AJAX URL

Hello,

My open URL button is passing 3 separate parameters dynamically as intended (Years, Months, Facility ID's), however I am approaching the URL character limit.

Is there a way to change my bolded query portion to not show all facility_id's within the URL Yield if the field remains un-selected (possible)?

URL QUERY

='https://devqvs.bedashboard.com/QvAJAXZfc/opendoc.htm?

document=OST%20PART%202%20FINAL.qvw&host=QVS%40eisdev-qvs0&Sheet=SH04

&Select=LB244,' & Concat(DISTINCT Year,',') 

& if(isMonthSelected=1, '&Select=LB243,' & Concat(DISTINCT Month,',') ,'')

& if(IsFacilityNameSelected=1,'&Select=LB256,' & Concat(Distinct Facility_ID,','), if(IsFacilityIDPossible=1,'&Select=LB256,'& Concat(Distinct Facility_ID,','),'')) 

URL YIELD

https://devqvs.bedashboard.com/QvAJAXZfc/opendoc.htm?

document=OST%20PART%202%20FINAL.qvw&host=QVS%40eisdev-qvs0&Sheet=SH04

&Select=LB244,2015

&Select=LB243,Apr,Feb,Mar

&Select=LB256,22768,22769,22770,22771,22773,22775,22777,22778,22779,22780,22781,22782,22783,22784,22785,22786,22787,22788,22790,22791,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

0 Replies