Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Rolling 13 months data calculation

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.

Tags (2)
6 Replies
chauhans85
Esteemed Contributor

Rolling 13 months data calculation

can u give me sample data i will try out.

thanks

Sunil

Not applicable

Rolling 13 months data calculation

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.

Not applicable

Re: Rolling 13 months data calculation

Hi Rohit:

Try the attached QVW.  Hope, it helps

--Narasimha

Not applicable

Re: Rolling 13 months data calculation

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.

Not applicable

Rolling 13 months data calculation

H Rohit:

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

Thanks,

Narasimha K

Highlighted
Not applicable

Re: Rolling 13 months data calculation

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