topic YearMonth Last 12 Month in QlikView

YearMonth Last 12 Month

Thu, 14 May 2009 18:49:51 GMT

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

YearMonth Last 12 Month

Oleg_Troyansky — Thu, 14 May 2009 20:36:30 GMT

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

YearMonth Last 12 Month

Thu, 14 May 2009 21:47:42 GMT

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

YearMonth Last 12 Month

Oleg_Troyansky — Thu, 14 May 2009 21:55:20 GMT

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

YearMonth Last 12 Month

Tue, 19 May 2009 13:10:43 GMT

Hi Oleg,

Thanks for your Help.

Regards

Shideh