YearMonth Last 12 Month

[#1]

Hi,

I need to show a yearmonth by yearmonth comparison for the select yearmonth in Pivot table. My report has expression values for all the months of a year(YYYYMM format) but need to compare current select yearmonth (Last 12 Month) .

for Example: i select Feb 2008 , the value from Feb 2007, March 2007,....to Jan 2008, Feb 2008 to display.

Thanks

[Oleg_Troyansky]

I have a feeling that I just responded to the exact same question about a week ago...

You need a separate field to allow selection of the Year/Month, and then you can do one one of the two:

1. Either use Set Analysis to limit the data to the prior 12 months

2. Or, actually link the "selection" YearMonth to your transaction yearmonth and add "12Months_Flag" that would be equal to 1 for the 12 months prior to the "selection month" and equal to null() for all other months.

Oleg

[#3]

Hi Oleg,

Thanks , i don't know what i doing with Set Analysi to limit the data to the prior 12 months. I am working with Qlikview since 1 Monat .

this formel display Net_Value_Inv for the Year select.

=

Sum({$<Kalender.Kalender.Year={$(=Only(Kalender.Kalender.Year))}>}{$*BM01} Billing_Header.Billing_Header.Net_Value_Inv

)

do you have any Example QVW

Thanks

Regards

[Oleg_Troyansky]

No, unfortunately I don't have any sample QBWs... if you search the forum for similar questions, you'll see several examples for very similar problems.

Oleg

[#5 · Accepted solution]

Hi Oleg,

Thanks for your Help.

Regards

Shideh