topic Use a total value in an expression in QlikView https://community.qlik.com/t5/QlikView/Use-a-total-value-in-an-expression/m-p/221051#M73892 <HTML><HEAD></HEAD><BODY><P>Hello-How can I (or can I) use a column's total value in an expression -- but use that value in a different chart than the one it was originally calculated in? I want this value to stay static no matter what the user selects. Thanks! Tina</P></BODY></HTML> Tue, 28 Sep 2010 17:51:18 GMT 2010-09-28T17:51:18Z Use a total value in an expression https://community.qlik.com/t5/QlikView/Use-a-total-value-in-an-expression/m-p/221051#M73892 <HTML><HEAD></HEAD><BODY><P>Hello-How can I (or can I) use a column's total value in an expression -- but use that value in a different chart than the one it was originally calculated in? I want this value to stay static no matter what the user selects. Thanks! Tina</P></BODY></HTML> Tue, 28 Sep 2010 17:51:18 GMT https://community.qlik.com/t5/QlikView/Use-a-total-value-in-an-expression/m-p/221051#M73892 2010-09-28T17:51:18Z Use a total value in an expression https://community.qlik.com/t5/QlikView/Use-a-total-value-in-an-expression/m-p/221052#M73893 <HTML><HEAD></HEAD><BODY><P>You should be able to get the total of a column using the proper expression. You will need tohe expression used in the original chart and then probably the Aggr() function to aggreagate by your dimensions.</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Aggr(OrigExpression, OrigDim1, OrigDim2, OrigDim3)</PRE></BLOCKQUOTE>That would be the basis, but it really depends on your data set. <BR /><BR /> <P>Are you looking for one value for the entire second chart or does the expression need to be evaluate separately for each dimension in the second chart?</P><P>I would think creating the expression in a variable would be the best way to use it in the second chart, but that may depend on the details.</P></BODY></HTML> Tue, 28 Sep 2010 18:00:47 GMT https://community.qlik.com/t5/QlikView/Use-a-total-value-in-an-expression/m-p/221052#M73893 2010-09-28T18:00:47Z