topic Re: Im trying to get the column value and set it as a variable in QlikView https://community.qlik.com/t5/QlikView/Im-trying-to-get-the-column-value-and-set-it-as-a-variable/m-p/1290179#M846705 <HTML><HEAD></HEAD><BODY><P>erm sorry what do you mean by dimensions?</P></BODY></HTML> Tue, 28 Mar 2017 01:59:53 GMT 2017-03-28T01:59:53Z Im trying to get the column value and set it as a variable https://community.qlik.com/t5/QlikView/Im-trying-to-get-the-column-value-and-set-it-as-a-variable/m-p/1290177#M846703 <HTML><HEAD></HEAD><BODY><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/157802_Untitled.png" style="height: 83px; width: 620px;" /></P><P></P><P>For the growing accounts column i have the expression as =fabs(Column(8)='Growing') and for the total mode i set it to sum of rows</P><P>how am i suppose to retrieve 328 and set it into a variable</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Im-trying-to-get-the-column-value-and-set-it-as-a-variable/m-p/1290177#M846703 2020-11-25T16:16:04Z Re: Im trying to get the column value and set it as a variable https://community.qlik.com/t5/QlikView/Im-trying-to-get-the-column-value-and-set-it-as-a-variable/m-p/1290178#M846704 <HTML><HEAD></HEAD><BODY><P>=sum(aggre(fabs(copy expression from column <span class="lia-unicode-emoji" title=":smiling_face_with_sunglasses:">😎</span> , dimension 1 used in straight table , dimension 2..ect )</P></BODY></HTML> Tue, 28 Mar 2017 01:46:06 GMT https://community.qlik.com/t5/QlikView/Im-trying-to-get-the-column-value-and-set-it-as-a-variable/m-p/1290178#M846704 vvvvvvizard 2017-03-28T01:46:06Z Re: Im trying to get the column value and set it as a variable https://community.qlik.com/t5/QlikView/Im-trying-to-get-the-column-value-and-set-it-as-a-variable/m-p/1290179#M846705 <HTML><HEAD></HEAD><BODY><P>erm sorry what do you mean by dimensions?</P></BODY></HTML> Tue, 28 Mar 2017 01:59:53 GMT https://community.qlik.com/t5/QlikView/Im-trying-to-get-the-column-value-and-set-it-as-a-variable/m-p/1290179#M846705 2017-03-28T01:59:53Z Re: Im trying to get the column value and set it as a variable https://community.qlik.com/t5/QlikView/Im-trying-to-get-the-column-value-and-set-it-as-a-variable/m-p/1290180#M846706 <HTML><HEAD></HEAD><BODY><P>Nvm thanks for the help bro i got it by using the macro </P><P></P><P>Sub Get_Growing_Accounts</P><P>Application.WaitForIdle</P><P>set cell=ActiveDocument.GetSheetObject("CH53").GetCell(1,10)</P><P>ActiveDocument.Variables("Get Growing Accounts").SetContent cell.text, True</P><P>set cell=nothing</P><P>End Sub</P></BODY></HTML> Tue, 28 Mar 2017 02:20:49 GMT https://community.qlik.com/t5/QlikView/Im-trying-to-get-the-column-value-and-set-it-as-a-variable/m-p/1290180#M846706 2017-03-28T02:20:49Z