Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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.
I s !end a example of you need.
Regards!!
Hello,
Mr Hugo thanks you
I tried but it did not work !!!
Knowing I want the same result
Thanks you