topic Re: Dimensions based on start date in Water Cooler

Dimensions based on start date

ChristinaMatier — Fri, 07 Feb 2020 22:09:31 GMT

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 🙂

Re: Dimensions based on start date

Sue_Macaluso — Fri, 15 Nov 2019 15:04:46 GMT

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

Re: Dimensions based on start date

Apprentice4life — Wed, 11 Dec 2019 19:59:22 GMT

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.