Dimensions based on start date

[ChristinaMatier]

Hi,

I have a combo chart for analysing two sets of data - Market Share and Company Share.

I want to be able to accumulate my data based on a 24 month rolling period - so the trend should remain pretty steady, however - although I only want to SHOW 24 month worth of data in my chart, I want the accumulation to start from previous data, i.e my displayed date range will begin Oct 2017, but I want that value to contain Oct + the last 23 months prior.

I cant use set analysis in my expression as it will only accumulate 24 months, i need to restrict my Dimension I guess?

If the 'Limit values' had a 'last' function instead of 'first' - that would be ideal, but it doesn't.

All help welcome 🙂

[Sue_Macaluso]

@ChristinaMatier Are you using QlikView or Sense?  I would like to move this into the correct product forum. Thanks

[Apprentice4life · Accepted solution]

Perhaps declare your date ranges as variables.

Max(Calendar) as variable1

Addmonths(variable1, -23) as variable2

This way you can use the two variables in the set analysis expressions.