2 Replies Latest reply: Jul 14, 2014 5:11 AM by ramu v RSS

    setting variable value to one or zero based mulitiple selection in list

      hi,

      I have requirement in qlik view where when a user do selection in list tab are activated for eg if a building id 1 or 2 is selected which belongs a group  then tab should be activated else deactivated.

      i have achieved this by putting condition to variable value as varHideSheet=if(buildingid=1 or buildingid=2 ,1,0) but when user selects both buildings 1 and 2 at the same time or 1 and 3 2 and 3 then  this condition fails and user want if and one building belongs the group the sheet should be activated

       

      please help me how can i achieve this

       

      Regards

      Ramu