topic Set Analysis between to dates in QlikView

Set Analysis between to dates

Fri, 09 Apr 2010 18:13:47 GMT

Can somebody help me her?

sum({$ <Date={$(=<only(Date)-1>only(Date)-60)}>} Sales)

I am trying to get sum of sales between selected date-60 and selected date-1

mike_garcia — Fri, 09 Apr 2010 18:22:24 GMT

Hello,

You can try:

sum({$<Date = {">=$(=only(Date)-60)<=$(=only(Date)-1)"}>} Sales)

Regards,

Mike.

spsrk_84 — Tue, 20 Apr 2010 06:11:05 GMT

can u give some example for the scenario what u said

so that it will be easy to give the solution

Tue, 20 Apr 2010 07:41:28 GMT

Hi Marius,

I hope you will find some helpful information.

Good luck!

Rainer