How to get dynamic sum for last 30 days

[#1]

I am doing a weekly report whereby every Monday, I need to get some metrics (eg, site visit, sales) for last week, and compare it with the figure 2 weeks back. I can solve that by using weekstart(Date)

I also need to do a 30days-to-date tracking, but I can't use monthstart() function because it only works for 1st day of the month. I also can't use accumulation because I dont want to display all 30 days in the dimension.

Any function I could use to sum the data for past 30 days for every monday?

[MayilVahanan]

HI

Try with AddMonths() function

Ex: AddMonths(Date, - 1)

[jjordaan]

Hi Adam,

You can create a days ago counter in your calendar and then as an expression you can do something like

Sum({<DayAgo = {'< 31'}>} Sales).

[jyothish8807]

Hi Adam,

PFA. Addmonths function will be useful.

Regards

KC

[amit_saini]

Adam ,

This may help u:

http://community.qlik.com/message/436471#436471

http://community.qlik.com/message/277059#277059

Thanks,
AS

[Anonymous]

Hi try the below expression

=Sum( If( AddMonths(Today(),-1) ,Sales))