topic Re: Previous Quarter in QlikView

Previous Quarter

Thu, 26 Feb 2015 16:59:58 GMT

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 — Thu, 26 Feb 2015 17:05:11 GMT

Create AutoNumber for Quarter in your Script..

maxgro — Thu, 26 Feb 2015 17:11:18 GMT

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 — Tue, 28 Apr 2015 23:22:06 GMT