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'&vCom...'
& if(IsYearSelected=1,'&Select=LBYear,' & Concat(DISTINCT Year,',') ,'')
& if(IsMonthSelected=1, '&Select=LBMonth,' & Concat(DISTINCT Month,',') ,'&Select=LBMonth,(*)')