topic Re: Pivoting in macro in QlikView https://community.qlik.com/t5/QlikView/Pivoting-in-macro/m-p/340860#M577082 <HTML><HEAD></HEAD><BODY><P>I have found the correct answer. It's like this :</P><P></P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>SUB mySUB</P><P>&nbsp;&nbsp;&nbsp;&nbsp; SET chart = ActiveDocument.Activesheet.CreatePivotTable</P><P>&nbsp;&nbsp;&nbsp;&nbsp; chart.AddDimension "Product"</P><P><SPAN style="font-family: 'Lucida Grande', Arial, Helvetica, sans-serif; white-space: pre; background-color: #ffffff;">&nbsp;&nbsp;&nbsp;&nbsp; chart.AddDimension "Year"</SPAN></P><P><SPAN style="font-family: 'Lucida Grande', Arial, Helvetica, sans-serif; white-space: pre; background-color: #ffffff;">&nbsp;&nbsp;&nbsp;&nbsp; chart.AddExpression "sum(Amount)"<BR /></SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; cp = chart.GetProperties</P><P>&nbsp;&nbsp;&nbsp;&nbsp; cp.TableProperties.<SPAN style="color: #ff0000;">NumberOfLeftDimensions</SPAN> = 1</P><P>&nbsp;&nbsp;&nbsp;&nbsp; chart.SetProperties cp </P><P>END SUB</P></PRE></BODY></HTML> Tue, 08 May 2012 14:34:38 GMT azimabadi 2012-05-08T14:34:38Z Pivoting in macro https://community.qlik.com/t5/QlikView/Pivoting-in-macro/m-p/340859#M577081 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>how can i do "Pivoting" in VBScript macro?</P><P>that means that for example, i have created a PivotTable with two dimensions in my macro and then i need to send one of this dimensions on horizontal axis.</P><P></P><P>Best regards</P><P>Peyman</P></BODY></HTML> Tue, 08 May 2012 09:42:55 GMT https://community.qlik.com/t5/QlikView/Pivoting-in-macro/m-p/340859#M577081 azimabadi 2012-05-08T09:42:55Z Re: Pivoting in macro https://community.qlik.com/t5/QlikView/Pivoting-in-macro/m-p/340860#M577082 <HTML><HEAD></HEAD><BODY><P>I have found the correct answer. It's like this :</P><P></P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>SUB mySUB</P><P>&nbsp;&nbsp;&nbsp;&nbsp; SET chart = ActiveDocument.Activesheet.CreatePivotTable</P><P>&nbsp;&nbsp;&nbsp;&nbsp; chart.AddDimension "Product"</P><P><SPAN style="font-family: 'Lucida Grande', Arial, Helvetica, sans-serif; white-space: pre; background-color: #ffffff;">&nbsp;&nbsp;&nbsp;&nbsp; chart.AddDimension "Year"</SPAN></P><P><SPAN style="font-family: 'Lucida Grande', Arial, Helvetica, sans-serif; white-space: pre; background-color: #ffffff;">&nbsp;&nbsp;&nbsp;&nbsp; chart.AddExpression "sum(Amount)"<BR /></SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; cp = chart.GetProperties</P><P>&nbsp;&nbsp;&nbsp;&nbsp; cp.TableProperties.<SPAN style="color: #ff0000;">NumberOfLeftDimensions</SPAN> = 1</P><P>&nbsp;&nbsp;&nbsp;&nbsp; chart.SetProperties cp </P><P>END SUB</P></PRE></BODY></HTML> Tue, 08 May 2012 14:34:38 GMT https://community.qlik.com/t5/QlikView/Pivoting-in-macro/m-p/340860#M577082 azimabadi 2012-05-08T14:34:38Z