Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ecrobles18
Contributor III
Contributor III

How to Create a 12 month Flag to Include the Current Month

Hello All,

I have a requirement where I need to create a 12 month flag in my master calendar that would include the current month. I currently have a flag for the previous 12 months, ,InMonths(12, D, Today(), -1, num(month(Today()))) as Previous12Months, however I can't figure out the logic to generate the 12 month flag that includes the current month. This means that I would want to capture the current month with the previous 11.The intent is to use this flag as a filter in on an nPrinting report to automate some biweekly reports. Can anyone lend a hand? Any help would be much appreciated.

- Emmanuel

1 Reply
felipedl
Partner
Partner

Hi Emmanuel,

On the calendar generation, try this:

let varMinDate = 40000;

let varMaxDate = Num(Today());

Calendar:

Load

*,

if(Num>=Num(MonthStart(AddMonths(Today(),-11))),1,0) as [Flag 12 Months];

LOAD 

    $(varMinDate) + Iterno()-1 As Num, 

    Date($(varMinDate) + IterNo() - 1) as TempDate

AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate); 

That will set every date on your calendar based on the current month date.

Thing is you'll have to reprocess the calendar every month, as to include more dates.

sample.png

In this way, only dates that are on the past 12 months will be flaged.

Felipe.