compare current quarter with previous quarter

[Anonymous]

Hi All

i have two text box.

first text box have to return the maximum quarter and maximum year that means : 2014-Q4

second textbox have to return the previous quarter of the maximum year that means 2014-Q3

suppose if select Year 2013 and select quarter 1 it has be return like this 2013-Q1 (tb1) vs 2012-Q3 (tb2)

Can you help me to create the formula

FiscalMonth	Month	Yr	Finquarter
01	Nov	2014	1
02	Dec	2012	1
03	Jan	2013	1
04	Feb	2014	2
05	Mar	2013	2
06	Apr	2014	2
07	May	2014	3
08	Jun	2012	3
09	Jul	2012	3
10	Aug	2014	4
11	Sep	2014	4
12	Oct	2013	4

[CELAMBARASAN]

Current Year Quarter

=Max(Yr) & '-Q' &Max(Finquarter)

Previous Quarter

=If(Max(Finquarter)=1, (Max(Yr)-1) & '-Q4', Max(Yr) & '-Q' & (Max(Finquarter) -1))

or

//=If(Max(Finquarter)=1, Max(Yr)-1, Max(Yr)) & '-Q' & (Mod(2+Max(Finquarter),4)+1)

[ashfaq_haseeb · Accepted solution]

Hi,

Check this

http://community.qlik.com/docs/DOC-7045

Regards

ASHFAQ