Set analysis with two variables

[#1]

Hello all,

I am trying to create a set analysis formula which allows me to select a current date which then returns two things.

1) All the revenue from that month preceeding and including the selected date.

2) All the revenue from that month after the selected date.

Then I need to be able to tell it to go to a different Month by adding a +/- 1.

The field names are RunDate and Revenue.

I would appreciate any suggestions as I seem to be banging my head against a wall with this.

[stevedark]

I have posted up shared QlikView's showing Set Analysis based around dates:

http://community.qlik.com/qlikviews/1175

And changing date variables using buttons:

http://community.qlik.com/qlikviews/1246

Using a combination of the tequniques in these two you should be able to get to the solution you require.

Hope that helps.

Steve