Qlik Tidbit – 4

Current Quarter Formula: 

Let vCurrentQtr = ceil(month(Today())/3);

‘Q’ & $(vCurrentQtr);

Previous Quarter Formula: 

Let vPreviousQtr = if(Mod(fabs(vCurrentQtr-1),4)=0, 4, Mod(fabs(vCurrentQtr-1),4));

Previous Quarter Year Formula:

Let vCurrentYear = Year(Today());

Let vPreviousYear = vCurrentYear;

Let vPrevQtrYear = if (vPreviousQtr=4, vPreviousYear, vCurrentYear);