Providing a List to select the columns to be made available in pivot table

[mohanraj94]

Hi All,

I want to give an user a list of column names. so they can select the columns they want to see in the pivot table.

I have already created a list and I am using (show column if option and adding the formula if(Match(list,'column_name'),1,0)  to it). But it only works if we select only one column from the list. if we select two or more column it is not working

Does anyone know how to achieve it

[rwunderlich · Accepted solution]

Instead try:

Max(Match(list,'column_name'))

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[mohanraj94]

Hi,

Thanks for your help. It is working. However even If none of the values are selected in the list. Views are showing all the column names.

Is there are any way to fix it? The View has to show the column names only if I select the column names in the list

[mohanraj94]

Hi All,

I found a solution, we just need to add the below formula in adds on

=If (getselectedcount(list)>0,1,0)