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

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

Thu, 10 Jul 2014 03:55:14 GMT

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

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

sasikanth — Thu, 10 Jul 2014 05:31:40 GMT

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

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

Mon, 14 Jul 2014 09:11:39 GMT

thanks it worked