topic Re: rolling seven days Set analysis in QlikView

rolling seven days Set analysis

Fri, 07 Jun 2013 08:28:53 GMT

hi i would like to calculate a value;

Rolling seven days (today-7 days)

sum(Levererat Antal)

i have the following syntax which is incorrect i see;

sum({<Leveransdatum={today()-7}>}[Levererat Antal])

Best,

Brad

Re: rolling seven days Set analysis

sushil353 — Fri, 07 Jun 2013 08:32:17 GMT

Try this:

sum({<Leveransdatum={'$(=Date(today()-7,'MM/DD/YYYY')'}>}[Levererat Antal])

I am assuming that Leveransdatum has date format like MM/DD/YYYY.

HTH

Sushil

Re: rolling seven days Set analysis

Fri, 07 Jun 2013 08:39:14 GMT

Hi i still have syntax error,

Re: rolling seven days Set analysis

sushil353 — Fri, 07 Jun 2013 08:42:58 GMT

Sorry, there is an error

Try this one:

sum({<Leveransdatum={'$(=Date(today()-7,'MM/DD/YYYY'))'}>}[Levererat Antal])

Re: rolling seven days Set analysis

Fri, 07 Jun 2013 08:48:00 GMT

Hi it is not working unfortunately,

do i need to create a new variable?

i have already a variable that vToday = Today() -7;

can i use this in the expression

=sum({<Leveransdatum={'$(=vToday,'YYYY-MM-DD)'}>}[Levererat Antal])

Date format is also YYYY-MM-DD

Best,

Bradley

Re: rolling seven days Set analysis

thomas_skariah — Fri, 07 Jun 2013 08:51:19 GMT

Hi,

You can try with the below code.

sum({<date={">=$(=AddMonths(Max(date-6),0))<=$(=Max(date))"}>} Value).

Regards,

Tom

Re: rolling seven days Set analysis

sushil353 — Fri, 07 Jun 2013 08:51:46 GMT

Try this:

vToday =Date(Today() -7,'YYYY-MM-DD')

Then expression

=sum({<Leveransdatum={'$(vToday)'}>}[Levererat Antal])

=sum({<Leveransdatum={"=$(vToday)"}>}[Levererat Antal])

if still it is not working then post the sample application.

HTH

Sushil