topic rolling 7 days back in QlikView

rolling 7 days back

Fri, 08 Feb 2013 08:03:03 GMT

Hello, how do i get Data from 7 days back?

So for example if i sum(Price)

I want it to show price for today, the 7th, 6th, 5th, 4th, 3th and so on..

Can i make it in a variable??

Re: rolling 7 days back

fdelacal — Fri, 08 Feb 2013 08:31:37 GMT

create a variable

vToday= today()

sum({<Year=,Date={">=$(=date(vToday-7,'MM/DD/YY'))"}>}Price)

Trie with this.

Regards.

Re: rolling 7 days back

Fri, 08 Feb 2013 08:35:51 GMT

that works - What is doing the rolling back? is it 'MM/DD/YY' which express that it should roll back? or how come i have to specifiy what date format it is??

Re: rolling 7 days back

fdelacal — Fri, 08 Feb 2013 08:46:30 GMT

No i put 'MM/DD/YY' as example.. you can change to your format.

yo say 7 day from today in (vToday-7 and you say that it can be >=...

if today is 08/02/2013.. today -7 is 01/02/2013 then you tell that will be >=..

sorry about my english..

Hope it helps you.

Re: rolling 7 days back

Fri, 08 Feb 2013 08:48:50 GMT

it worked - i just wanted to understand why it worked:) But i think i got the picture. Thankyou very much