Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a requirement to generate previous 12 month flag.
I have data at weekly level. So if in current year say we have data from Jan2015 to Dec-2015(but only 2 weeks of Dec--Dec is not complete month, it is partial)
so for previous 12 month flag as well i want to consider partial periods (same time period-jan 2014 to mid Dec 2014). How to generate flag for that?
Thanks
Khushboo
can you be more specific in your requirement please ? I guess a sample of input you have and what output you want will be helpful.
I don't understand what you want to flag compared to what. Can you post a small qlikview document with some example data that explains what you're trying to do.
Why do you want to flag like this ? if you want sum of measures last 12 months?
Check this article this will help
Do you mean you want to create flag for Previous year Year-To-Date?
Have a look at below links:
How to use - Master-Calendar and Date-Values
Rolling 12 months flag in master calendar script? | Qlik Community
I hope it is helpful