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

[#1]

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

[sasikanth · Accepted solution]

Hi ramu

please find the attached file,

you have to use the condtion like,

if(getSelectedCount(filed-name)>0 and Substing(concat(field-name),'value'),1,0)

Have a look into the file

[#3]

thanks it worked