topic Re: Previous 12 month flag in QlikView

Previous 12 month flag

Wed, 19 Oct 2016 08:04:36 GMT

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

Re: Previous 12 month flag

Wed, 19 Oct 2016 08:08:50 GMT

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.

Re: Previous 12 month flag

Gysbert_Wassenaar — Wed, 19 Oct 2016 08:15:43 GMT

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.

Re: Previous 12 month flag

lakshmikandh — Wed, 19 Oct 2016 08:26:46 GMT

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

Re: Previous 12 month flag

shraddha_g — Wed, 19 Oct 2016 09:20:37 GMT

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

Re: Previous 12 month flag

shraddha_g — Wed, 19 Oct 2016 09:29:11 GMT

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