Rolling 13 months data calculation

[#1]

Hi,

I am new to qlikview. My requirement is to show a chart with months on X axis and four measures on Y axis.

But I need to show rolling 13 months on X axis which should vary as per user selection.

i.e. from list box of monthyear if user selects May2010 then on X axis of chart months from Apr2010 to Apr2009 should get displayed.

I am not much familier with how to write script.

Please guide me in this.

[SunilChauhan]

can u give me sample data i will try out.

thanks

Sunil

[#3]

I cannot give you the data .

But I can tell you table structure.

Date table and Fact table are joined on 'DateKEY' which is lowest level in date table.

User has to select one date to run the report.

Then report need to show data from fact table for rolling 13 months as I explained in my original post.

Please help me out.

[#4]

Hi Rohit:

Try the attached QVW.  Hope, it helps

--Narasimha

[#5]

Hi Narasimha,

Thanks for you answer.

This is what I wanted.

But could you please let me know now if I want to use database data instead of inline data, what changes are needed in this?

I am new to it, please let me know.

Thanks in advance.

[#6]

H Rohit:

Depending on the format of the date, you should tweak the Load statement.

Thanks,

Narasimha K

[#7]

Thanks Narasimha, I had the same requirement and it worked for me.