topic QTQ comparison in QlikView

QTQ comparison

Wed, 22 Sep 2010 11:53:10 GMT

Hi all

can anyone help me how to compare the quarter to quarter...

i.e., selecting the 2nd month in Q1 will compare to the 2nd month in preceding quarters

thanks in advance

Wed, 22 Sep 2010 12:31:18 GMT

hi gopinathanl

i m not cleare about ur question.

make a inline table like this:

Month_Map:

LOAD

* INLINE [

Month, Quarter

Jan, Q1

Feb, Q1

Mar, Q1

Apr, Q2

May, Q2

jun,Q2

Jul,Q3

Aug, Q3

Sep, Q3

Oct, Q4

Nov, Q4

Dec, Q4

];

then make your chart by first dimenssion Quarter with ur expression.

try this

thanks

zaman

Wed, 22 Sep 2010 13:49:41 GMT

To get the relative month within the quarter, use the following formula :

Example : July = month 7 in 3rd quarter. July is the first month within 3rd quarter

Formula = num(month(<datefield>)) - (num(quarter(<datefield>))-1)*3

On the example : 7 - (3-1)*3 = 1

November for example would lead to : 11 - (4-1)*3 = 2

That should do the trick.

You will now be able to select the relative month within the different quarters