topic Create a pivot with rows and columns in script in QlikView https://community.qlik.com/t5/QlikView/Create-a-pivot-with-rows-and-columns-in-script/m-p/304546#M587035 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>from an empty PIVOT chart, i'm adding dimensions and expressions with a script through functions like that :</P><P>chart.AddDimension </P><P>chart.AddExpression</P><P></P><P>but how can i say that i want the dimensions to be seen on rows or colums ?</P><P>the user can drag the rows into columns&nbsp; but is it possible to do it in design time ?</P><P></P><P>Thanks </P></BODY></HTML> Mon, 25 Jul 2011 16:57:36 GMT 2011-07-25T16:57:36Z Create a pivot with rows and columns in script https://community.qlik.com/t5/QlikView/Create-a-pivot-with-rows-and-columns-in-script/m-p/304546#M587035 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>from an empty PIVOT chart, i'm adding dimensions and expressions with a script through functions like that :</P><P>chart.AddDimension </P><P>chart.AddExpression</P><P></P><P>but how can i say that i want the dimensions to be seen on rows or colums ?</P><P>the user can drag the rows into columns&nbsp; but is it possible to do it in design time ?</P><P></P><P>Thanks </P></BODY></HTML> Mon, 25 Jul 2011 16:57:36 GMT https://community.qlik.com/t5/QlikView/Create-a-pivot-with-rows-and-columns-in-script/m-p/304546#M587035 2011-07-25T16:57:36Z Re: Create a pivot with rows and columns in script https://community.qlik.com/t5/QlikView/Create-a-pivot-with-rows-and-columns-in-script/m-p/304547#M587036 <HTML><HEAD></HEAD><BODY><P>Check property NumberOfLeftDimensions</P><P></P><P>Sample from APIGUIDE</P><P></P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>rem Create HLO system table on new sheet</P><P>set Sheet=ActiveDocument.CreateSheet</P><P>set Hlo=Sheet.CreatePivotTable</P><P>Hlo.AddDimension "$Field"</P><P>Hlo.AddDimension "$Table"</P><P>Hlo.AddExpression "Only([$Field])"</P><P>set Prop = Hlo.GetProperties</P><P>Prop.TableProperties.PivotAlwaysFullyExpanded=true</P><P>Prop.Dimensions.Item(0).SortCriteria.SortByAscii=0</P><P>Prop.Dimensions.Item(0).SortCriteria.SortByLoadOrder=1</P><P>Prop.Dimensions.Item(1).SortCriteria.SortByAscii=0</P><P>Prop.Dimensions.Item(1).SortCriteria.SortByLoadOrder=1</P><P>Prop.TableProperties.NumberOfLeftDimensions = 1 </P><P>Hlo.SetProperties Prop</P><P></P></PRE></BODY></HTML> Mon, 25 Jul 2011 18:03:09 GMT https://community.qlik.com/t5/QlikView/Create-a-pivot-with-rows-and-columns-in-script/m-p/304547#M587036 danielrozental 2011-07-25T18:03:09Z Create a pivot with rows and columns in script https://community.qlik.com/t5/QlikView/Create-a-pivot-with-rows-and-columns-in-script/m-p/304548#M587037 <HTML><HEAD></HEAD><BODY><P>Excellent, thank you !</P></BODY></HTML> Mon, 25 Jul 2011 20:45:40 GMT https://community.qlik.com/t5/QlikView/Create-a-pivot-with-rows-and-columns-in-script/m-p/304548#M587037 2011-07-25T20:45:40Z