topic expression in straight table in QlikView https://community.qlik.com/t5/QlikView/expression-in-straight-table/m-p/818526#M288593 <HTML><HEAD></HEAD><BODY><P>I have a table contains a couple of expressions. One of them is Insufficient QTY, and I have no clue how to get the result I need. The correct result should be the column in yellow in Excel file. see attachment.</P><P>Anyone can help me with this? The key in this table is style, color,label. The sequence of this table is fixed. And Insufficient QTY is based on Remaining Inventory.</P><P></P><P>Many thanks.</P></BODY></HTML> Mon, 05 Jan 2015 19:25:39 GMT newhere2014 2015-01-05T19:25:39Z expression in straight table https://community.qlik.com/t5/QlikView/expression-in-straight-table/m-p/818526#M288593 <HTML><HEAD></HEAD><BODY><P>I have a table contains a couple of expressions. One of them is Insufficient QTY, and I have no clue how to get the result I need. The correct result should be the column in yellow in Excel file. see attachment.</P><P>Anyone can help me with this? The key in this table is style, color,label. The sequence of this table is fixed. And Insufficient QTY is based on Remaining Inventory.</P><P></P><P>Many thanks.</P></BODY></HTML> Mon, 05 Jan 2015 19:25:39 GMT https://community.qlik.com/t5/QlikView/expression-in-straight-table/m-p/818526#M288593 newhere2014 2015-01-05T19:25:39Z