0 Replies Latest reply: Oct 21, 2016 9:32 AM by Kevin Warren RSS

    URL Passing Parameter Query Select DeSelect?

    Kevin Warren

      I am not having much luck passing DeSelected List Box options within my query successfully. Once a List Box option is selected (I.E. Year 2015) then I deselect it, my URL parameter still passes the year 2015 that was previously selected.

       

      See examples in RED.

      I can choose to select all for Month, however I would prefer to not have any selected or highlighted green for the user.

       

      ='https://devqvs.bedashboard.com/QvAJAXZfc/opendoc.htm?document='&vDocumentEncoded&'&host=QVS%40'&vComputer&'&Sheet=Overview'

      & if(IsYearSelected=1,'&Select=LBYear,' & Concat(DISTINCT Year,',') ,'')

      & if(IsMonthSelected=1, '&Select=LBMonth,' & Concat(DISTINCT Month,',') ,'&Select=LBMonth,(*)')