overlapping dimension in table?

pepe2209 — Wed, 20 Aug 2014 12:57:38 GMT

I would like to create a table that has the following dimensions:

Company	period
1	last 3 months (month 08-14 to 06-14)
1	last 6 months (month 08-14 to 03-14)
1	last 12 months (month 08-14 to 09-13)
2	last 3 months (month 08-14 to 06-14)
2	last 6 months (month 08-14 to 03-14)
2	last 12 months (month 08-14 to 09-13)

So dimension one is just company and in the second dimension i would like show the results for the last 3, 6 and 12 months of that company. So there is an overlap of months. I tried to use a dimension with distinct months (last 3, from 4 to 6, from 7 to 12) and then use accumulation or the "above" function in expressions, but I don't know what's most efficient.

your help would be much appreciated

regards,

Peter

Re: overlapping dimension in table?

Gysbert_Wassenaar — Wed, 20 Aug 2014 13:17:47 GMT

Perhaps with expressions like this:

sum({<[MyDate]={'>$(=addmonths(monthend(today()),-3))'}>}Amount)

sum({<[MyDate]={'>$(=addmonths(monthend(today()),-6))'}>}Amount)

sum({<[MyDate]={'>$(=addmonths(monthend(today()),-12))'}>}Amount)

topic overlapping dimension in table? in QlikView

overlapping dimension in table?

Re: overlapping dimension in table?