topic Macro to change PivotTable Dimension Transparency in QlikView https://community.qlik.com/t5/QlikView/Macro-to-change-PivotTable-Dimension-Transparency/m-p/398050#M148240 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I have a requirement that requires my users to add/remove additional dimensions to the existing Pivot Table. Since, I need the existing dimensions to be displayed along with the ones the users choose, I am using a Macro to incorporate that functionality. When I add dimensions:</P><P></P><P>1. The dimension column label background inherits the chart properties background color (which is required).</P><P>2. However, the dimension data also inherits the chart properties which makes the background color white. I need to make this transparent like the rest of the pivot table. (which I had initially done through custom format cell)</P><P></P><P>Can this be done using a macro or is there a workaround? </P><P></P><P>Thanks in Advance!</P></BODY></HTML> Tue, 11 Sep 2012 21:33:35 GMT 2012-09-11T21:33:35Z Macro to change PivotTable Dimension Transparency https://community.qlik.com/t5/QlikView/Macro-to-change-PivotTable-Dimension-Transparency/m-p/398050#M148240 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I have a requirement that requires my users to add/remove additional dimensions to the existing Pivot Table. Since, I need the existing dimensions to be displayed along with the ones the users choose, I am using a Macro to incorporate that functionality. When I add dimensions:</P><P></P><P>1. The dimension column label background inherits the chart properties background color (which is required).</P><P>2. However, the dimension data also inherits the chart properties which makes the background color white. I need to make this transparent like the rest of the pivot table. (which I had initially done through custom format cell)</P><P></P><P>Can this be done using a macro or is there a workaround? </P><P></P><P>Thanks in Advance!</P></BODY></HTML> Tue, 11 Sep 2012 21:33:35 GMT https://community.qlik.com/t5/QlikView/Macro-to-change-PivotTable-Dimension-Transparency/m-p/398050#M148240 2012-09-11T21:33:35Z