topic Rolling Calendar and IF Statement in App Development

Rolling Calendar and IF Statement

Mon, 28 Aug 2017 19:01:31 GMT

I have a rolling 13 month calendar that is used for several clients. However one client's data only starts in Feb 2017.

I need an if statement so any months prior to Feb 2017 will not show (If RollingStartDate is < Feb 2017 ???.

How do I add that to the below?

Let vYear = Year(Today()-1);

Let vPriorYear = Year(Today()-1)-1;

Let vRollingStartDate = Date(MonthStart(AddMonths(Today()-1, -12)));

Let vToday = Date(Today()-1);

Thanks for the assist - Jim

felipedl — Mon, 28 Aug 2017 19:59:17 GMT

Hi James,

If you have the RollingStartDate in the standard excel format and have created the date in View, the if statement can be as follows:

if (RollingStartDate < 42767,... // 42767 is the equivalent of 02/01/2017 or February 1st in Excel.

Felipe.

Mon, 28 Aug 2017 20:07:22 GMT

Hi Felipe

Thank you

How would I add that to the code I gave? (New to Qlik Sense)

Eventually the 13 month calendar would kick in.

felipedl — Mon, 28 Aug 2017 21:23:11 GMT

Let vYear = Year(Today()-1);

Let vPriorYear = Year(Today()-1)-1;

if (Date(MonthStart(AddMonths(Today()-1, -12))) < 42767) then

Let vRollingStartDate = 42767;

else

Let vRollingStartDate = Date(MonthStart(AddMonths(Today()-1, -12)));

end if;

Let vToday = Date(Today()-1);

In this logic, if twelve months back is lesser then feb 2017, it wil start from feb on, and if not, it will get 12 months back.

Felipe.

Mon, 28 Aug 2017 21:40:10 GMT

This is fantastic - just what I needed to help me understand

Thank you - it has been marked as correct.