Previous Quarter

[#1]

Hi,

Trying to derive Current Quarter and Previous Quarter for the Value available and have stuck in Detrmining Previous Quarter.

The value  available is :

Current is : Q12015.

How to determing Previous , i.e. here : Q42014 ?

Any help appreciated.

Thanks!

[MK_QSL]

Create AutoNumber for Quarter in your Script..

[maxgro]

for string

=if(left('Q22015',2)='Q1', 'Q4' & (right('Q22015',4)-1), 'Q' & (mid('Q22015',2,1)-1) & right('Q22015',4))

replace 'Q22015' with your quarter field

=if(left(Reporting_Quarter,2)='Q1', 'Q4' & (right(Reporting_Quarter,4)-1), 'Q' & (mid(Reporting_Quarter,2,1)-1) & right(Reporting_Quarter,4))

[prabhu0505]

Qlik Tidbit – 4 | QlikTab