https://community.qlik.com/t5/QlikView/Expression-Question/m-p/2021944#M1222089 <P>Hello, any ideas? I am still stuck</P> Wed, 04 Jan 2023 21:06:52 GMT dataexplorer 2023-01-04T21:06:52Z https://community.qlik.com/t5/QlikView/Expression-Question/m-p/2019087#M1221995 <P>Hello QlikView Community,</P> <P>I am trying to write an expression in a Text Object, where it does the following</P> <P>(Avg Price (current period)-Avg Price(baseline period))*Qty(current period)</P> <P>Then sum the above expression to calculate inflation/deflation</P> <P>The expression needs to be on the front end, so that the user can select the current period and baseline period. Thank you in advance for assistance.&nbsp;</P> <P>Here is a sample data&nbsp;</P> <P>Current period - Nov-2022 Baseline Period - Dec-2021</P> <TABLE style="height: 97px; width: 100%;" border="1" width="100%"> <TBODY> <TR> <TD width="25%" height="47px">Month-Year</TD> <TD width="25%" height="47px">Material-ID</TD> <TD width="25%" height="47px">Inv. Value&nbsp;</TD> <TD width="12.5%" height="47px">Stock Qty</TD> <TD width="12.5%" height="47px">Avg Price</TD> </TR> <TR> <TD width="25%">Nov-22</TD> <TD width="25%">AAA</TD> <TD width="25%">942.39</TD> <TD width="12.5%">37</TD> <TD width="12.5%">25.47</TD> </TR> <TR> <TD width="25%">Nov-22</TD> <TD width="25%">BBB</TD> <TD width="25%">942.34</TD> <TD width="12.5%">2</TD> <TD width="12.5%">471.17</TD> </TR> <TR> <TD width="25%">Nov-22</TD> <TD width="25%">CCC</TD> <TD width="25%">941.5</TD> <TD width="12.5%">14</TD> <TD width="12.5%">67.25</TD> </TR> <TR> <TD width="25%">Nov-22</TD> <TD width="25%">DDD</TD> <TD width="25%">941.5</TD> <TD width="12.5%">14</TD> <TD width="12.5%">67.25</TD> </TR> <TR> <TD width="25%">Nov-22</TD> <TD width="25%">EEE</TD> <TD width="25%">940.96</TD> <TD width="12.5%">8</TD> <TD width="12.5%">117.62</TD> </TR> <TR> <TD width="25%">Nov-22</TD> <TD width="25%">XXX</TD> <TD width="25%">940.3</TD> <TD width="12.5%">5</TD> <TD width="12.5%">188.06</TD> </TR> <TR> <TD width="25%">Dec-21</TD> <TD width="25%">AAA</TD> <TD width="25%">85.29</TD> <TD width="12.5%">3</TD> <TD width="12.5%">28.43</TD> </TR> <TR> <TD width="25%">Dec-21</TD> <TD width="25%">BBB</TD> <TD width="25%">475.15</TD> <TD width="12.5%">1</TD> <TD width="12.5%">475.15</TD> </TR> <TR> <TD width="25%">Dec-21</TD> <TD width="25%">CCC</TD> <TD width="25%">941.5</TD> <TD width="12.5%">14</TD> <TD width="12.5%">67.25</TD> </TR> <TR> <TD width="25%">Dec-21</TD> <TD width="25%">DDD</TD> <TD width="25%">295.35</TD> <TD width="12.5%">11</TD> <TD width="12.5%">26.85</TD> </TR> <TR> <TD width="25%">Dec-21</TD> <TD width="25%">EEE</TD> <TD width="25%">940.96</TD> <TD width="12.5%">8</TD> <TD width="12.5%">117.62</TD> </TR> <TR> <TD width="25%">Dec-21</TD> <TD width="25%">XXX</TD> <TD width="25%">1013.1</TD> <TD width="12.5%">5</TD> <TD width="12.5%">202.62</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 21 Dec 2022 17:15:04 GMT https://community.qlik.com/t5/QlikView/Expression-Question/m-p/2019087#M1221995 dataexplorer 2022-12-21T17:15:04Z https://community.qlik.com/t5/QlikView/Expression-Question/m-p/2021944#M1222089 <P>Hello, any ideas? I am still stuck</P> Wed, 04 Jan 2023 21:06:52 GMT https://community.qlik.com/t5/QlikView/Expression-Question/m-p/2021944#M1222089 dataexplorer 2023-01-04T21:06:52Z