Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
swatitomar
Contributor III
Contributor III

12 months cumm on each bar

hey hi,

I have a question regarding 12 Months Cumm...

Suppose I have 3 yrs data(2011,2012,2013) with me..i want that if  i select

Mar2013 then it show (Apr2012-Mar2013) data in single bar

Apr2013  then   (May2012-Apr2013)

-

-

Jan2014 then   (Dec2013-Jan2014)..

In short On selection of Dec2014 i want that in chart data should display from Jan2013 Feb2013 ........Dec2014

n in Jan 2013 data of Feb2012-Jan2013

Feb2013 data of MAr2012-Feb2013

and so on

thanks in Advance

4 Replies
effinty2112
Master
Master

Hello,

This is fairly easy if you have a master calendar with a MonthID field that is an integer the runs sequentially for each month.

Suppose in your calendar Mar2013 is MonthID 47 and you select this month.

An expression that gives the result you want will use a set analysis set modifier such as

<MonthID = {"<=$(=max(MonthID))>=$(=max(MonthID)-11)"}>

this is like hard writing <MonthID = {"<=47>=36"}>

You may need to add other parts to your set analysis to get the correct result. If you have select 2013 in the Year field in addition to selecting a month the expression will exclude records outside of 2013 unless you add the term Year = to the expression which causes the expression to disregards selections in the Year field:

<MonthID = {"<=$(=max(MonthID))>=$(=max(MonthID)-11)"}, Year = >


Cheers

swatitomar
Contributor III
Contributor III
Author

@ ! !
hey Andrew,

thanks for your reply but I think my question is not clear to you..

now i am attaching 1 qvw where i tried to do the think but i failed ..

In qvw Final Tab, please select MonthYear (Mar-09 )then you will see in chart called (Final table)0 value in front of Apr08-Mar09 ,

But there i want 100 as this chart it use to  shows the cummulation of 5 months ...

It is doing cummulation but when the value of some brand comes 0 ,it don't do but i want....

For that i have taken calender Master also in practice then also i am facing the issue ..

Please help ..Its really ugrent..

ecolomer
Master II
Master II

Here you have an example:

swatitomar
Contributor III
Contributor III
Author

Yes Enquire,

I am Attaching here what exactly i want.Please dont forget i want this thing with 2 dimension not 1.For Idea.PNG