https://community.qlik.com/t5/QlikView/Calculation-method-for-a-field/m-p/1619733#M445672 <P>hello ,</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;all i am trying to calculate average selling price ( dollars / quantity )for an item that is sold in the company . The calculation method is to find unique values based upon the key ( which is&nbsp; Item &amp; region code&amp; week ) everything is fine until when there exits a match based upon the key . The issue arrives when there is no match , the calculation in this scenario is&nbsp;&nbsp;to find unique values based upon the key ( which is&nbsp; Item &amp; region code&amp; <STRONG>week minus one&nbsp;</STRONG> ) . i tried various methods by doing all the necessary calculations&nbsp;&nbsp;for Item &amp; region code&amp; <STRONG>week minus one&nbsp;</STRONG> separately&nbsp; in the script and joined to the data model ( didn't work). i did some front end expression by using variables didn't work . any help would be great . All the tables&nbsp; in the dashboard are connected by&nbsp; unique key ( which is Item &amp; region code&amp; week ).</P> Sat, 16 Nov 2024 02:34:50 GMT Shiva123 2024-11-16T02:34:50Z https://community.qlik.com/t5/QlikView/Calculation-method-for-a-field/m-p/1619733#M445672 <P>hello ,</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;all i am trying to calculate average selling price ( dollars / quantity )for an item that is sold in the company . The calculation method is to find unique values based upon the key ( which is&nbsp; Item &amp; region code&amp; week ) everything is fine until when there exits a match based upon the key . The issue arrives when there is no match , the calculation in this scenario is&nbsp;&nbsp;to find unique values based upon the key ( which is&nbsp; Item &amp; region code&amp; <STRONG>week minus one&nbsp;</STRONG> ) . i tried various methods by doing all the necessary calculations&nbsp;&nbsp;for Item &amp; region code&amp; <STRONG>week minus one&nbsp;</STRONG> separately&nbsp; in the script and joined to the data model ( didn't work). i did some front end expression by using variables didn't work . any help would be great . All the tables&nbsp; in the dashboard are connected by&nbsp; unique key ( which is Item &amp; region code&amp; week ).</P> Sat, 16 Nov 2024 02:34:50 GMT https://community.qlik.com/t5/QlikView/Calculation-method-for-a-field/m-p/1619733#M445672 Shiva123 2024-11-16T02:34:50Z