topic Re: expression in QlikView https://community.qlik.com/t5/QlikView/expression/m-p/1131277#M890003 <HTML><HEAD></HEAD><BODY><P>hi sunny</P><P></P><P>attached excel/</P></BODY></HTML> Thu, 18 Aug 2016 12:57:35 GMT raadwiptec 2016-08-18T12:57:35Z expression https://community.qlik.com/t5/QlikView/expression/m-p/1131275#M890001 <HTML><HEAD></HEAD><BODY><P>my earlier requirement has changed to following need another new expression on the front end..</P><P></P><P>I have the following 3 columns</P><P>1. Billing Type </P><P>2. Quantity</P><P>3. Location</P><P></P><P>Billing Types are '6001','6002','6003','6554','5101','5102','5251','5352','7401','7302','4951','3952','2961','9362',<SPAN style="font-size: 13.3333px;">2001','2002'</SPAN></P><P></P><P>Based on the Billing Types quantity should be derived as below</P><P></P><P>-6001+2001+2002-6002-6003-6554-5101-5102-5251-5352-7401-7302-4951-3952-2961-9362</P><P>Note: - Consider the quantities of 2001 and 2002 only If the Location is Null</P><P>Foe example the above shows if the billing type is 6001 then it should be quantiy *-1</P><P>Suggest here</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/expression/m-p/1131275#M890001 raadwiptec 2020-11-25T16:16:04Z Re: expression https://community.qlik.com/t5/QlikView/expression/m-p/1131276#M890002 <HTML><HEAD></HEAD><BODY><P>I don't think I understand the logic you are using here, can you provide a sample data in an Excel file for all three columns and then tell the expected output?</P></BODY></HTML> Thu, 18 Aug 2016 12:33:14 GMT https://community.qlik.com/t5/QlikView/expression/m-p/1131276#M890002 sunny_talwar 2016-08-18T12:33:14Z Re: expression https://community.qlik.com/t5/QlikView/expression/m-p/1131277#M890003 <HTML><HEAD></HEAD><BODY><P>hi sunny</P><P></P><P>attached excel/</P></BODY></HTML> Thu, 18 Aug 2016 12:57:35 GMT https://community.qlik.com/t5/QlikView/expression/m-p/1131277#M890003 raadwiptec 2016-08-18T12:57:35Z