Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

1 Solution

Accepted Solutions
sasikanth
Master
Master

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

View solution in original post

2 Replies
sasikanth
Master
Master

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

Not applicable
Author

thanks it worked