topic Condition in list box in QlikView https://community.qlik.com/t5/QlikView/Condition-in-list-box/m-p/30478#M5055 <HTML><HEAD></HEAD><BODY><P>Dear Qlikers,</P><P>I've got in my application ad-hoc report. There's listbox with name of the columns to pick up in the chart. I'd like to part of the columns hide from part of the users (security reasons). I've use the following formula for list box A if(match(column_code,'A1'),column_name) and for the listbox B if(match(column_code,'B1'),column_name). The problem is when I select something from list box A it excludes selection from list box B. Both list boxes are using the same table.</P><P>One important fact - I cannot split the table into 2 - because one of the expressions needs to concatenate all column names.</P><P></P><P>I'd be grateful for any idea.</P><P></P><P>Thanks in advance for help.</P><P>M.</P></BODY></HTML> Thu, 15 Mar 2018 09:37:33 GMT salezian 2018-03-15T09:37:33Z Condition in list box https://community.qlik.com/t5/QlikView/Condition-in-list-box/m-p/30478#M5055 <HTML><HEAD></HEAD><BODY><P>Dear Qlikers,</P><P>I've got in my application ad-hoc report. There's listbox with name of the columns to pick up in the chart. I'd like to part of the columns hide from part of the users (security reasons). I've use the following formula for list box A if(match(column_code,'A1'),column_name) and for the listbox B if(match(column_code,'B1'),column_name). The problem is when I select something from list box A it excludes selection from list box B. Both list boxes are using the same table.</P><P>One important fact - I cannot split the table into 2 - because one of the expressions needs to concatenate all column names.</P><P></P><P>I'd be grateful for any idea.</P><P></P><P>Thanks in advance for help.</P><P>M.</P></BODY></HTML> Thu, 15 Mar 2018 09:37:33 GMT https://community.qlik.com/t5/QlikView/Condition-in-list-box/m-p/30478#M5055 salezian 2018-03-15T09:37:33Z Re: Condition in list box https://community.qlik.com/t5/QlikView/Condition-in-list-box/m-p/30479#M5056 <HTML><HEAD></HEAD><BODY><P>Use Alternate State.</P><P></P><P><A href="http://www.qlikfix.com/2014/08/12/alternate-states/" title="http://www.qlikfix.com/2014/08/12/alternate-states/">http://www.qlikfix.com/2014/08/12/alternate-states/</A></P><P><A href="https://community.qlik.com/thread/114739">what is alternate states in Qlikview ?</A></P></BODY></HTML> Thu, 15 Mar 2018 09:52:10 GMT https://community.qlik.com/t5/QlikView/Condition-in-list-box/m-p/30479#M5056 MK_QSL 2018-03-15T09:52:10Z