Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
Valued Contributor III

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

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

2 Replies
sasikanth
Valued Contributor III

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

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

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

thanks it worked

Community Browser