https://community.qlik.com/t5/App-Development/Sum-Orders-with-Total-Order-Value-lt-1M-and-Quarter-to-Quarter/m-p/2513959#M105409 <P>You can do a search in set analysis like:</P><P>Sum({&lt;OrderNo={"=sum(Amount)&gt;=1000"}&gt;} Amount)</P><P>I have attached an example with three different ways of solving it</P> Fri, 11 Apr 2025 05:51:31 GMT morgankejerhag 2025-04-11T05:51:31Z https://community.qlik.com/t5/App-Development/Sum-Orders-with-Total-Order-Value-lt-1M-and-Quarter-to-Quarter/m-p/2513586#M105362 <P>Hello,</P> <P>I need to replicate this Excel graph. My data set is Sales Orders.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="fvillarr_0-1744144674179.png" style="width: 366px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/179470iECC4770FD0A15A3E/image-dimensions/366x171?v=v2" width="366" height="171" role="button" title="fvillarr_0-1744144674179.png" alt="fvillarr_0-1744144674179.png" /></span></P> <P>I'm struggling on two issues:</P> <P>1- How to calculate the sum of orders lower than 1M. My data set has the orders split by products, so I assume I first need to find the total order value.</P> <P>For reference this is the formula I'd use to get the total value of all orders:<BR />Sum({&lt;[Snapshot Date Type]={'Yesterday','Q4FY2425','Q3FY2425','Q2FY2425','Q1FY2425'}&gt;}[# Net Revenue Spot r.USD])</P> <P>And this is one that I tried, but since an order can be in multiple snapshots I get errors. I'd need the total order value in a single quarter.<BR />Sum({$&lt; [Snapshot Date Type]={'Yesterday','Q4FY2425','Q3FY2425','Q2FY2425','Q1FY2425'},[Order Number]={"=sum({&lt;[Snapshot Date Type]={'Yesterday','Q4FY2425','Q3FY2425','Q2FY2425','Q1FY2425'}&gt;}[# Net Revenue Spot r.USD])&gt;1000000"}&gt;}[# Net Revenue Spot r.USD])</P> <P>You can see here how it works fine when an order exists only once, but is broken by the order that goes across two quarters.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="fvillarr_0-1744151997720.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/179472iCF54E3CF6B8FDD48/image-size/medium?v=v2&amp;px=400" role="button" title="fvillarr_0-1744151997720.png" alt="fvillarr_0-1744151997720.png" /></span></P> <P>&nbsp;</P> <P><BR /><BR />2- I don't know how to calculate that trend line with the Quarter to Quarter variations.</P> <P>&nbsp;</P> <P>I'd appreciate any help you can give me.</P> Tue, 08 Apr 2025 22:40:49 GMT https://community.qlik.com/t5/App-Development/Sum-Orders-with-Total-Order-Value-lt-1M-and-Quarter-to-Quarter/m-p/2513586#M105362 fvillarr 2025-04-08T22:40:49Z https://community.qlik.com/t5/App-Development/Sum-Orders-with-Total-Order-Value-lt-1M-and-Quarter-to-Quarter/m-p/2513959#M105409 <P>You can do a search in set analysis like:</P><P>Sum({&lt;OrderNo={"=sum(Amount)&gt;=1000"}&gt;} Amount)</P><P>I have attached an example with three different ways of solving it</P> Fri, 11 Apr 2025 05:51:31 GMT https://community.qlik.com/t5/App-Development/Sum-Orders-with-Total-Order-Value-lt-1M-and-Quarter-to-Quarter/m-p/2513959#M105409 morgankejerhag 2025-04-11T05:51:31Z https://community.qlik.com/t5/App-Development/Sum-Orders-with-Total-Order-Value-lt-1M-and-Quarter-to-Quarter/m-p/2514267#M105463 <P>Thank you!<BR />Unfortunately I don't own the app and cannot modify the load script. I was hoping to solve it in Set Analysis without building any additional flags or tables in the script.</P> Mon, 14 Apr 2025 13:55:36 GMT https://community.qlik.com/t5/App-Development/Sum-Orders-with-Total-Order-Value-lt-1M-and-Quarter-to-Quarter/m-p/2514267#M105463 fvillarr 2025-04-14T13:55:36Z