topic Re: Expression Mapping in QlikView https://community.qlik.com/t5/QlikView/Expression-Mapping/m-p/921252#M986550 <HTML><HEAD></HEAD><BODY><P>Perhaps this discussion helps: <A href="https://community.qlik.com/thread/67420">Expressions in Fields</A>. Make sure to read the comment of <A href="https://community.qlik.com/qlik-users/13229">jontydkpi</A>‌</P></BODY></HTML> Thu, 30 Jul 2015 09:17:09 GMT Gysbert_Wassenaar 2015-07-30T09:17:09Z Expression Mapping https://community.qlik.com/t5/QlikView/Expression-Mapping/m-p/921251#M986549 <HTML><HEAD></HEAD><BODY><P>Hi&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>I'm looking at this problem and trying to think of the best approach to use</P><P></P><P>I have a table each report name with refer to a particular item in the calculation sometimes more than once for eg</P><P></P><P>Location&nbsp;&nbsp;&nbsp; Report&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dimension&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Calculation used</P><P>London&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sum("Set analysis expression to pick the sum of lines for report 3, location London Dimension SD")</P><P>London&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Same as above</P><P></P><P>Was wondering the most efficient way to do this ?</P><P></P><P>Currently I have an inline table for columns 1 -3&nbsp; and I'm using a pivot table with set analysis expressions to generate results. The complication later comes when I need to use formulas to refer to other results in the table.</P><P></P><P>Am I doing it in the most best practice way ?</P><P></P><P></P><P>Thanks</P><P></P><P></P><P>Sarah </P></BODY></HTML> Thu, 30 Jul 2015 08:46:51 GMT https://community.qlik.com/t5/QlikView/Expression-Mapping/m-p/921251#M986549 2015-07-30T08:46:51Z Re: Expression Mapping https://community.qlik.com/t5/QlikView/Expression-Mapping/m-p/921252#M986550 <HTML><HEAD></HEAD><BODY><P>Perhaps this discussion helps: <A href="https://community.qlik.com/thread/67420">Expressions in Fields</A>. Make sure to read the comment of <A href="https://community.qlik.com/qlik-users/13229">jontydkpi</A>‌</P></BODY></HTML> Thu, 30 Jul 2015 09:17:09 GMT https://community.qlik.com/t5/QlikView/Expression-Mapping/m-p/921252#M986550 Gysbert_Wassenaar 2015-07-30T09:17:09Z