topic Re: How to build a sum by using multiple criteria in QlikView https://community.qlik.com/t5/QlikView/How-to-build-a-sum-by-using-multiple-criteria/m-p/415349#M483994 <HTML><HEAD></HEAD><BODY><P>Hi, please find the solution in the attached application.</P></BODY></HTML> Tue, 28 May 2013 16:19:07 GMT jvitantonio 2013-05-28T16:19:07Z How to build a sum by using multiple criteria https://community.qlik.com/t5/QlikView/How-to-build-a-sum-by-using-multiple-criteria/m-p/415346#M483991 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I'm totally new to QlikView an wondered if there is a workaround that is like SUMIFS-command by Excel.</P><P></P><P>I have a tablle with the following columns date, cashflow, buy/sell, person, location. product</P><P></P><P>I would like to define two new series' that contain contain either the positiv or negative cashflows per day overall persons and locations.</P><P></P><P>Can you give me an advice how to draw this up?</P><P></P><P>Thanks in advance</P><P></P><P></P><P>QV_Scrub</P></BODY></HTML> Tue, 28 May 2013 13:40:06 GMT https://community.qlik.com/t5/QlikView/How-to-build-a-sum-by-using-multiple-criteria/m-p/415346#M483991 2013-05-28T13:40:06Z Re: How to build a sum by using multiple criteria https://community.qlik.com/t5/QlikView/How-to-build-a-sum-by-using-multiple-criteria/m-p/415347#M483992 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">Hi</SPAN></P><P><SPAN class="hps">Can you post</SPAN> <SPAN class="hps">an example</SPAN>?</P></BODY></HTML> Tue, 28 May 2013 13:42:23 GMT https://community.qlik.com/t5/QlikView/How-to-build-a-sum-by-using-multiple-criteria/m-p/415347#M483992 rphpacheco 2013-05-28T13:42:23Z Re: How to build a sum by using multiple criteria https://community.qlik.com/t5/QlikView/How-to-build-a-sum-by-using-multiple-criteria/m-p/415348#M483993 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>assume the following table:</P><P></P><P>Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In/Out&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Person</P><P>01.01.2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Max</P><P>01.01.2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Carl</P><P>01.01.2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Out&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tim</P><P>01.01.2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Out&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Max</P><P>02.01.2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Out&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tim</P><P>03.01.2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Paul&nbsp;&nbsp;&nbsp; </P><P></P><P>What I would like to generate is a table as follows</P><P></P><P>Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value_In&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value_Out</P><P>01.01.2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 700</P><P>02.01.2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>03.01.2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P></P><P></P><P>So my intention is to define to new variables that represent each one of the both columns "Value_In" and "Value_Out".</P><P></P><P></P><P>Thanks.</P><P></P><P>BR</P><P></P><P>QV_Scrub&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Tue, 28 May 2013 16:07:28 GMT https://community.qlik.com/t5/QlikView/How-to-build-a-sum-by-using-multiple-criteria/m-p/415348#M483993 2013-05-28T16:07:28Z Re: How to build a sum by using multiple criteria https://community.qlik.com/t5/QlikView/How-to-build-a-sum-by-using-multiple-criteria/m-p/415349#M483994 <HTML><HEAD></HEAD><BODY><P>Hi, please find the solution in the attached application.</P></BODY></HTML> Tue, 28 May 2013 16:19:07 GMT https://community.qlik.com/t5/QlikView/How-to-build-a-sum-by-using-multiple-criteria/m-p/415349#M483994 jvitantonio 2013-05-28T16:19:07Z Re: How to build a sum by using multiple criteria https://community.qlik.com/t5/QlikView/How-to-build-a-sum-by-using-multiple-criteria/m-p/415350#M483995 <HTML><HEAD></HEAD><BODY><P>Can you provide it as a txt-file?</P></BODY></HTML> Tue, 28 May 2013 16:33:28 GMT https://community.qlik.com/t5/QlikView/How-to-build-a-sum-by-using-multiple-criteria/m-p/415350#M483995 2013-05-28T16:33:28Z Re: How to build a sum by using multiple criteria https://community.qlik.com/t5/QlikView/How-to-build-a-sum-by-using-multiple-criteria/m-p/415351#M483996 <HTML><HEAD></HEAD><BODY><P>Create a pivot table and 2 expressions:</P><P></P><P>In Value:</P><P>sum( {$&lt;InOut = {"In"}&gt;} Value)</P><P></P><P>Out Value:</P><P>sum( {$&lt;InOut = {"Out"}&gt;} Value)</P><P></P><P>InOut is your "In/Out" field in your example.</P><P>The dimension for this chart should be Date.</P><P></P><P>I hope this helps.</P></BODY></HTML> Tue, 28 May 2013 16:46:40 GMT https://community.qlik.com/t5/QlikView/How-to-build-a-sum-by-using-multiple-criteria/m-p/415351#M483996 jvitantonio 2013-05-28T16:46:40Z