max (YearMonth) as Demension in Pivottable

[#1]

Hi,

I am trying to to display L12 Sales of data in a pivot table based on calender Year and Month for each Calender Year-Month as Demension. see my Example QlikView.

Thanks

[#2]

you didn't attach any qlikview document

[prieper]

Think that ADDMONTHS() might help you a bit:

Sum(IF(Date > Addmonths(Today(), -12) AND Date < Today(), Sales) in an expression

IF(Date > Addmonths(Today(), -12) AND Date < Today(), Date) as a dimension (and do not show NULL-values)

HTH
Peter

[#4]

Hi,

sorry attached my qlickView

[#5]

Hi,

sorry , attached my QlikView

[#6]

seems u r havin trouble attachin the doc!!!

[#7]

again

[#8]

Hi,

i try again

[#9]

Will be good if you can elaborate, wat u wanted to achieve!!

[#10]

Hi Richy,

Thank for your Help and sorry for my bad englisch.

i try to explain you:

I'd like for each year month the sales L12.

For Example:

When I select in calendar Year 2006 and Month June

1)

Jun 2006 = sum (Sales (July2005+Aug.2005+Sep.2005+Ok.2005+Now.2005+Dec.2005+Jan.2006+Feb.2006+March2006+Apr.2006+May.2006+Jun2006)) +

2)

May 2006 =sum(Sales (Jun.2005+Jul.2005+Aug.2005+Sep.2005+Ok.2005+Now.2005+Dec.2005+Jan.2006+Feb.2006+March2006+Apr.2006+May.2006)) +

3)

April 2006 =sum(Sales (May.2005 +Jun.2005+Jul.2005+Aug.2005+Sep.2005+Ok.2005+Now.2005+Dec.2005+Jan.2006+Feb.2006+March2006+Apr.2006)) +

4)

March 2006 =( sum(Sales (Apr.2005 + May.2005 +Jun.2005+Jul.2005+Aug.2005+Sep.2005+Ok.2005+Now.2005+Dec.2005+Jan.2006+Feb.2006+March2006)) +

The same formel till

July 2005

The dimension schould be (L12 Month from select Calendar Month)

Jun 2006 = value (1)

May2006 =value (2)

April 2006 =value (3)

March 2006 =value(4)

Feb 2006 = et cetera

Jan 2006 = …..

Dec 2005 = …..

Nov 2005

Okt 2005

Sep 2005

Aug 2005

July 2005

Thanks