Set analysis with two variables

Wed, 02 May 2012 19:29:00 GMT

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 — Wed, 02 May 2012 20:41:48 GMT

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

And changing date variables using buttons:

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

Hope that helps.

Steve

topic Set analysis with two variables in QlikView