Dear Qlikers,
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.
One important fact - I cannot split the table into 2 - because one of the expressions needs to concatenate all column names.
I'd be grateful for any idea.
Thanks in advance for help.
M.
