https://community.qlik.com/t5/App-Development/Calculate-sum-up-to-one-day-via-a-variable/m-p/2480473#M100723 <P>Hello all,</P> <P>I want to use the slicer to determine the day of my variable vDay.<BR />The sum should be calculated up to this day. So add up all quantities that are smaller than my selected day. <BR />Can someone give me a description / show me how to set this up?</P> <P>Thank you!</P> Fri, 15 Nov 2024 20:52:28 GMT Just6 2024-11-15T20:52:28Z https://community.qlik.com/t5/App-Development/Calculate-sum-up-to-one-day-via-a-variable/m-p/2480473#M100723 <P>Hello all,</P> <P>I want to use the slicer to determine the day of my variable vDay.<BR />The sum should be calculated up to this day. So add up all quantities that are smaller than my selected day. <BR />Can someone give me a description / show me how to set this up?</P> <P>Thank you!</P> Fri, 15 Nov 2024 20:52:28 GMT https://community.qlik.com/t5/App-Development/Calculate-sum-up-to-one-day-via-a-variable/m-p/2480473#M100723 Just6 2024-11-15T20:52:28Z https://community.qlik.com/t5/App-Development/Calculate-sum-up-to-one-day-via-a-variable/m-p/2480569#M100724 <P>Your variable vDay should be defined as =Max(YourDateField)</P> <P>Your Slicer's data field should be&nbsp;YourDateField</P> <P>Now you can use the vDay in your expression.<BR />Sum({&lt; YourDateField = {"&lt;=$(vDay)"} &gt;} SalesQuantity)<BR /><BR /></P> Tue, 10 Sep 2024 03:12:22 GMT https://community.qlik.com/t5/App-Development/Calculate-sum-up-to-one-day-via-a-variable/m-p/2480569#M100724 Aasir 2024-09-10T03:12:22Z