Previous 12 month flag

[#1]

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

[#2]

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.

[Gysbert_Wassenaar]

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.

[lakshmikandh]

Why do you want to flag like this ? if you want sum of measures last 12 months?

Relative Calendar Fields

Check this article this will help

[shraddha_g]

Do you mean you want to create flag for Previous year Year-To-Date?

[shraddha_g]

Have a look at below links:

Creating A Master Calendar

How to use - Master-Calendar and Date-Values

Rolling 12 months flag in master calendar script? | Qlik Community

I hope it is helpful