Put the twelve month rolling as axis

[#1]

Hello,

I need your help to solve my problem.

I want to edit a calculated dimension that displays the list of twelve months rolling from a variable input by the user (vToday)

Would it be possible to have this list?

Thanks for your feedback

Best regards

[#2]

I want a list of the months-years

This list must match the difference between start and end date

Example: start date = '11 / 06/2016 'and end date = '20 / 10/2016'

List = 06/2016 07/2016 08/2016 09/2016 10/2016

Thank you

[Gysbert_Wassenaar]

It's usually a better idea to modify the expressions instead of using a calculated dimension. Please post a small qlikview document with example data so we can see what kind of date fields you have available.

[MK9885]

If( TempDate > monthstart(addmonths(today(),-11)) and TempDate <= today(),1)

as [Rolling 12]

You can use the above syntax in your Master Calendar (If you've one) script. If you do not have master Calendar then make one.

You'll get available script in community and it will also have Rolling12 months data.

[#5]

I s !end a example of you need.

Regards!!

[#6]

Hello,

Mr Hugo thanks you

I tried but it did not work !!!

Knowing I want  the same result

Thanks you