topic Using a cell value in an expression in QlikView https://community.qlik.com/t5/QlikView/Using-a-cell-value-in-an-expression/m-p/170001#M40583 <HTML><HEAD></HEAD><BODY><P>Good day everyone</P><P>I'm been scratching my head over this for a little while now. I have a pivot table with rolling weeks as the columns, and expressions as rows. The user needs to select a single product before he can see this table.</P><P>My first row is the opening stock balance, my second is sales, and my third is confirmed purchase orders for that specific week. This is where the problem comes in. The purpose of this table is to display the weeks when there will be no more stock (based on the opening stock balance - actuals + confirmed po's ) I use the following formula to calculate the following week's opening stock balance:</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">=Before(Sum([OnHand])) - Before(Sum([ActualQty])) + Before(Sum([ConfirmedPO]))</PRE><BR /><BR /> <P>The problem is that my opening stock value is always the same, no matter which week I'm in, thus the formula works great for the week that it's in, but it doesn't take the "re-calculated" opening balance for the next week. So I was wondering if there is a way to get a cell value into an expression. Or if there are any suggestions on a work-around?</P><P>Your help is (as always) greatly appreciated.</P></BODY></HTML> Tue, 01 Dec 2009 17:11:51 GMT 2009-12-01T17:11:51Z Using a cell value in an expression https://community.qlik.com/t5/QlikView/Using-a-cell-value-in-an-expression/m-p/170001#M40583 <HTML><HEAD></HEAD><BODY><P>Good day everyone</P><P>I'm been scratching my head over this for a little while now. I have a pivot table with rolling weeks as the columns, and expressions as rows. The user needs to select a single product before he can see this table.</P><P>My first row is the opening stock balance, my second is sales, and my third is confirmed purchase orders for that specific week. This is where the problem comes in. The purpose of this table is to display the weeks when there will be no more stock (based on the opening stock balance - actuals + confirmed po's ) I use the following formula to calculate the following week's opening stock balance:</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">=Before(Sum([OnHand])) - Before(Sum([ActualQty])) + Before(Sum([ConfirmedPO]))</PRE><BR /><BR /> <P>The problem is that my opening stock value is always the same, no matter which week I'm in, thus the formula works great for the week that it's in, but it doesn't take the "re-calculated" opening balance for the next week. So I was wondering if there is a way to get a cell value into an expression. Or if there are any suggestions on a work-around?</P><P>Your help is (as always) greatly appreciated.</P></BODY></HTML> Tue, 01 Dec 2009 17:11:51 GMT https://community.qlik.com/t5/QlikView/Using-a-cell-value-in-an-expression/m-p/170001#M40583 2009-12-01T17:11:51Z