topic How to get expression's label in pivot table using macro? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-expression-s-label-in-pivot-table-using-macro/m-p/232753#M504212 <HTML><HEAD></HEAD><BODY><PRE style="margin:0px;">Sub Dims<BR /> set cht=ActiveDocument.GetSheetObject("CH01")<BR /><BR /> set Prop = cht.GetProperties<BR /> set dimz = Prop.Dimension ActiveDocument.Variables("vDim1").SetContent dimz.Item(0).Title.v,true<BR /> ActiveDocument.Variables("vDim2").SetContent dimz.Item(1).Title.v,true<BR /> ActiveDocument.Variables("vDim3").SetContent dimz.Item(2).Title.v,true<BR />End Sub<BR />try something like this for expressions.</PRE></BODY></HTML> Sat, 06 Feb 2010 07:16:55 GMT 2010-02-06T07:16:55Z How to get expression's label in pivot table using macro? https://community.qlik.com/t5/QlikView/How-to-get-expression-s-label-in-pivot-table-using-macro/m-p/232752#M504211 <HTML><HEAD></HEAD><BODY><P>Cos i need to enable or disable some expression depends on it's title.</P><P>Thanks a lot.</P></BODY></HTML> Sat, 06 Feb 2010 04:43:41 GMT https://community.qlik.com/t5/QlikView/How-to-get-expression-s-label-in-pivot-table-using-macro/m-p/232752#M504211 2010-02-06T04:43:41Z How to get expression's label in pivot table using macro? https://community.qlik.com/t5/QlikView/How-to-get-expression-s-label-in-pivot-table-using-macro/m-p/232753#M504212 <HTML><HEAD></HEAD><BODY><PRE style="margin:0px;">Sub Dims<BR /> set cht=ActiveDocument.GetSheetObject("CH01")<BR /><BR /> set Prop = cht.GetProperties<BR /> set dimz = Prop.Dimension ActiveDocument.Variables("vDim1").SetContent dimz.Item(0).Title.v,true<BR /> ActiveDocument.Variables("vDim2").SetContent dimz.Item(1).Title.v,true<BR /> ActiveDocument.Variables("vDim3").SetContent dimz.Item(2).Title.v,true<BR />End Sub<BR />try something like this for expressions.</PRE></BODY></HTML> Sat, 06 Feb 2010 07:16:55 GMT https://community.qlik.com/t5/QlikView/How-to-get-expression-s-label-in-pivot-table-using-macro/m-p/232753#M504212 2010-02-06T07:16:55Z