topic Re: Sum Date range in QlikView

Sum Date range

Anonymous — Fri, 25 May 2018 03:40:13 GMT

Hello,

I want to sum up to today -1 but in the example bellow I'm getting 0.

i'm trying:

=sum({$<S_Date={'>=$(=Date(min(S_Date)))<=$(=Date(today()-1)))'}>}Sales_limit)

sum from 16/05 to 23/05.

how can I do that?

Tks

S_Date	Sales_limit
16/05/2018	10
17/05/2018	20
18/05/2018	30
19/05/2018	40
20/05/2018	50
21/05/2018	60
22/05/2018	70
23/05/2018	80
24/05/2018	90
25/05/2018	100
26/05/2018	110
27/05/2018	120
28/05/2018	130
29/05/2018	140
30/05/2018	150

Re: Sum Date range

pradosh_thakur — Fri, 25 May 2018 04:12:10 GMT

Your field must be a date

=sum({$<S_Date={">=$(=Date(min(S_Date)))<=$(=Date(today()-1)))"}>}Sales_limit)

Re: Sum Date range

jonathandienst — Fri, 25 May 2018 04:48:37 GMT

Try this:

=Sum({<S_Date = {">='$(=Date(min(S_Date)))' <='$(=Date(today()-1))'"}>} Sales_limit)

Re: Sum Date range

Anonymous — Fri, 25 May 2018 12:28:56 GMT

which field? could you give an example please?

tks

Re: Sum Date range

Anonymous — Fri, 25 May 2018 12:30:19 GMT

tried but no success.

Follow the qvw.

tks

Re: Sum Date range

PrashantSangle — Fri, 25 May 2018 12:39:21 GMT

as jonathan suggested try with " (double quote).

It will work.

Regards,

Re: Sum Date range

Anonymous — Fri, 25 May 2018 12:44:11 GMT

tried but no success.

Re: Sum Date range

PrashantSangle — Fri, 25 May 2018 12:45:51 GMT

bro you have extra closing in set analysis check

try below

sum({$<S_Date={">=$(=Date(min(S_Date)))<=$(=Date(Today()-1))"}>}Sales_limit)

Regards,

Re: Sum Date range

Anonymous — Fri, 25 May 2018 12:50:01 GMT

Sorry, I just copied from Joanthan's post.

Try this:

=Sum({<S_Date = {">='$(=Date(min(S_Date)))' <='$(=Date(today()-1))'"}>} Sales_limit)

But no problem, Now i'ts working.

Why in this case should I use with double quotes?

Tks