topic Chart expression to lookup reference table? in QlikView https://community.qlik.com/t5/QlikView/Chart-expression-to-lookup-reference-table/m-p/735892#M1054853 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am trying to calculate a total price within a chart table when the unit price depends on two aggregated values(volume &amp; service level).&nbsp; The unit price is the same across all units so I just need a way of using the aggregated values to look up a reference table but there doesn't seem to be a chart function to do this?&nbsp; "Lookup()" would be ideal but it is only available as a script function.</P><P></P><P>Can anyone suggest a suitable chart function or an alternative approach?</P><P></P><P>Robin</P></BODY></HTML> Thu, 30 Oct 2014 23:18:56 GMT robinrouleur 2014-10-30T23:18:56Z Chart expression to lookup reference table? https://community.qlik.com/t5/QlikView/Chart-expression-to-lookup-reference-table/m-p/735892#M1054853 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am trying to calculate a total price within a chart table when the unit price depends on two aggregated values(volume &amp; service level).&nbsp; The unit price is the same across all units so I just need a way of using the aggregated values to look up a reference table but there doesn't seem to be a chart function to do this?&nbsp; "Lookup()" would be ideal but it is only available as a script function.</P><P></P><P>Can anyone suggest a suitable chart function or an alternative approach?</P><P></P><P>Robin</P></BODY></HTML> Thu, 30 Oct 2014 23:18:56 GMT https://community.qlik.com/t5/QlikView/Chart-expression-to-lookup-reference-table/m-p/735892#M1054853 robinrouleur 2014-10-30T23:18:56Z Re: Chart expression to lookup reference table? https://community.qlik.com/t5/QlikView/Chart-expression-to-lookup-reference-table/m-p/735893#M1054854 <HTML><HEAD></HEAD><BODY><P>Maybe the&nbsp; only() function works (...if [ExpressionTotal] = only(LookUpField)&nbsp; )&nbsp; , if there is one (lookup) value only else it returns false</P></BODY></HTML> Thu, 30 Oct 2014 23:26:01 GMT https://community.qlik.com/t5/QlikView/Chart-expression-to-lookup-reference-table/m-p/735893#M1054854 danieloberbilli 2014-10-30T23:26:01Z