topic Simple expression help in QlikView https://community.qlik.com/t5/QlikView/Simple-expression-help/m-p/195337#M55874 <HTML><HEAD></HEAD><BODY><P>It is simpler with pivot table, but if you have to use staright table - see attached.</P></BODY></HTML> Wed, 23 Dec 2009 01:43:09 GMT Anonymous 2009-12-23T01:43:09Z Simple expression help https://community.qlik.com/t5/QlikView/Simple-expression-help/m-p/195336#M55873 <HTML><HEAD></HEAD><BODY><P>I have a straight table chart with the following fields: CustomerName, Invoicenumber, InvoiceLineNo, LineTotal. Each invoice has several lines</P><P>I would like to display on the first line of each invoice (InvoiceLineNo=0) the amount of the entire invoice - something simular to a subtotal, but as an expression field in the straight table</P><P></P><P>What expression should I use? If it was just SQL, I would do a subquery to get that info. I looked into SET Analysis in the reference but was unable to find the proper way to do it.</P><P></P><P>Please help</P></BODY></HTML> Tue, 22 Dec 2009 23:03:27 GMT https://community.qlik.com/t5/QlikView/Simple-expression-help/m-p/195336#M55873 m4u 2009-12-22T23:03:27Z Simple expression help https://community.qlik.com/t5/QlikView/Simple-expression-help/m-p/195337#M55874 <HTML><HEAD></HEAD><BODY><P>It is simpler with pivot table, but if you have to use staright table - see attached.</P></BODY></HTML> Wed, 23 Dec 2009 01:43:09 GMT https://community.qlik.com/t5/QlikView/Simple-expression-help/m-p/195337#M55874 Anonymous 2009-12-23T01:43:09Z Simple expression help https://community.qlik.com/t5/QlikView/Simple-expression-help/m-p/195338#M55875 <HTML><HEAD></HEAD><BODY><P>Thanks alot</P></BODY></HTML> Wed, 23 Dec 2009 03:56:22 GMT https://community.qlik.com/t5/QlikView/Simple-expression-help/m-p/195338#M55875 m4u 2009-12-23T03:56:22Z