topic Re: Set analysis With difference in date in App Development

Set analysis With difference in date

Husky_Bab12 — Tue, 06 Sep 2022 02:05:51 GMT

Hi ,

I need to sum quantity based on input dates with below expression.

If the user enters 0 to 10 in the days input then I need to sum up the quantities between days 0 to 9

And if the user gives input has 18 to 25 , I need to some up quantities from 18 to 25 days

similarly , it needs to sum the quantity based on user input.

So the beginning date in the shift date always has the current date.

For example, if today is 2022-09-05. The Shift Date has date starting from 2022-09-05. And the end date is 70 days from current date.

I'm not sure whether I've defined the variable in a correct way.

Please, some one help let me know where I'm going wrong

=sum({<$(='[Shift Date]')={">=$(vStart)<=$(vEnd)"}>} Quantity)

output : 0

The shift date is in the format, 2022-09-02.

I'm receiving 0 no matter the input I give on vStart and vEnd.

Where the variables are defined as vStart= 0 and vEnd = 0.

Re: Set analysis With difference in date

Vegar — Tue, 06 Sep 2022 04:49:26 GMT

Try this:

=sum({<[Shift Date]={">='$(vStart)'<='$(vEnd)'"}>} Quantity)

I am assuming that both Shift Date, vStart and vEnd are formated as your application default date format.

Re: Set analysis With difference in date

SunilChauhan — Tue, 06 Sep 2022 05:19:16 GMT

use below

Sum({<Quantity={">=$(vQuantityStart)<=$(vQuantityEnd)"},Date={">=$(vMinDate)<=$(vMaxDate)"}>}Quantity)

using attached Excel and .qvf

you Can ENter min and Max Quanity , also Min Date and Result will Change according to entry.

Hope this helps