topic Re: How to disable a specific column from selection in Pivot table in QlikView https://community.qlik.com/t5/QlikView/How-to-disable-a-specific-column-from-selection-in-Pivot-table/m-p/554832#M1135600 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> if you could have the always fully expanded option, then you can put a transparent text over the field.</P></BODY></HTML> Mon, 14 Oct 2013 15:16:13 GMT bbi_mba_76 2013-10-14T15:16:13Z How to disable a specific column from selection in Pivot table https://community.qlik.com/t5/QlikView/How-to-disable-a-specific-column-from-selection-in-Pivot-table/m-p/554829#M1135597 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Currently I can make selection across the dimensions in the attached pivot table: Organisation, Business Group, Business Unit, Product</P><P></P><P>However, I want to disable the selection of ‘product’ in the privot table. Any ideal how this can be configured?</P><P></P><P>Many Thanks!</P><P>Heok</P></BODY></HTML> Mon, 14 Oct 2013 11:56:54 GMT https://community.qlik.com/t5/QlikView/How-to-disable-a-specific-column-from-selection-in-Pivot-table/m-p/554829#M1135597 2013-10-14T11:56:54Z Re: How to disable a specific column from selection in Pivot table https://community.qlik.com/t5/QlikView/How-to-disable-a-specific-column-from-selection-in-Pivot-table/m-p/554830#M1135598 <HTML><HEAD></HEAD><BODY><P>Maybe you can try using this set analysis in all your expressions : {&lt;keyProduct2=&gt;}</P><P></P><P>This will ignore the selection in product.</P><P></P><P>It is harder to prevent qlikview from making a selection.</P><P></P><P>regards</P><P>stephane</P></BODY></HTML> Mon, 14 Oct 2013 12:03:04 GMT https://community.qlik.com/t5/QlikView/How-to-disable-a-specific-column-from-selection-in-Pivot-table/m-p/554830#M1135598 2013-10-14T12:03:04Z Re: How to disable a specific column from selection in Pivot table https://community.qlik.com/t5/QlikView/How-to-disable-a-specific-column-from-selection-in-Pivot-table/m-p/554831#M1135599 <HTML><HEAD></HEAD><BODY><P>I tried that and it doesn't seems to work for my purpose.</P><P>Thanks anyway!</P></BODY></HTML> Mon, 14 Oct 2013 15:11:34 GMT https://community.qlik.com/t5/QlikView/How-to-disable-a-specific-column-from-selection-in-Pivot-table/m-p/554831#M1135599 2013-10-14T15:11:34Z Re: How to disable a specific column from selection in Pivot table https://community.qlik.com/t5/QlikView/How-to-disable-a-specific-column-from-selection-in-Pivot-table/m-p/554832#M1135600 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> if you could have the always fully expanded option, then you can put a transparent text over the field.</P></BODY></HTML> Mon, 14 Oct 2013 15:16:13 GMT https://community.qlik.com/t5/QlikView/How-to-disable-a-specific-column-from-selection-in-Pivot-table/m-p/554832#M1135600 bbi_mba_76 2013-10-14T15:16:13Z Re: How to disable a specific column from selection in Pivot table https://community.qlik.com/t5/QlikView/How-to-disable-a-specific-column-from-selection-in-Pivot-table/m-p/554833#M1135601 <HTML><HEAD></HEAD><BODY><P>Create a Text Object set the color to transparent and cover the product</P><P></P><P>see attached</P></BODY></HTML> Mon, 14 Oct 2013 15:21:24 GMT https://community.qlik.com/t5/QlikView/How-to-disable-a-specific-column-from-selection-in-Pivot-table/m-p/554833#M1135601 rustyfishbones 2013-10-14T15:21:24Z Re: How to disable a specific column from selection in Pivot table https://community.qlik.com/t5/QlikView/How-to-disable-a-specific-column-from-selection-in-Pivot-table/m-p/554834#M1135602 <HTML><HEAD></HEAD><BODY><P>This is a good idea to workaround. Thanks All!</P></BODY></HTML> Wed, 30 Oct 2013 09:32:34 GMT https://community.qlik.com/t5/QlikView/How-to-disable-a-specific-column-from-selection-in-Pivot-table/m-p/554834#M1135602 2013-10-30T09:32:34Z