topic Re: compare current quarter with previous quarter in QlikView

compare current quarter with previous quarter

Anonymous — Tue, 04 Nov 2014 09:52:16 GMT

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

CELAMBARASAN — Tue, 04 Nov 2014 10:12:25 GMT

Current Year Quarter

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

Previous Quarter

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

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

ashfaq_haseeb — Tue, 04 Nov 2014 10:13:59 GMT

Hi,

Check this

Regards

ASHFAQ