topic Rolling 13 months data calculation in QlikView

Rolling 13 months data calculation

Wed, 22 Jun 2011 12:02:17 GMT

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 — Wed, 22 Jun 2011 12:08:38 GMT

can u give me sample data i will try out.

thanks

Sunil

Wed, 22 Jun 2011 12:11:58 GMT

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.

Wed, 22 Jun 2011 15:26:04 GMT

Hi Rohit:

Try the attached QVW. Hope, it helps

--Narasimha

Thu, 23 Jun 2011 05:00:34 GMT

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.

Thu, 23 Jun 2011 08:00:02 GMT

H Rohit:

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

Thanks,

Narasimha K

Tue, 09 Feb 2016 21:56:19 GMT

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