Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
hemanthaanichet
Creator III
Creator III

To show growth of current year RQTR vs previous year RQTR in Bar Chart

Hi ,


Previously I posted this requirement in the blog  but  due to some urgency once again iam posting this

Rollling Quater Growth:

Formula: ( RQTR of Current Year  -  RQTR of Previous Year) / (RQTR of Previous Year )

Current year is latest 12 months i.e., Oct-12 - Sep-13

Previous year is previous latest 12 months i.e., Oct-11 - Sep12

Dimension should be latest 12 months i.e., Oct-12 - Sep-13

&

Sep-13 have a value which is equal to sum of sales for Sep-13,Aug-13,Jul-13

i.e., Sep-13 = sum({<Yearmonth={ Sep-13,Aug-13,Jul-13}>}sales)

       Aug-13 = sum({<Yearmonth={ Aug-13,Jul-13,Jun-13}>}sales)

       Jul-13 = sum({<Yearmonth={ Jul-13,Jun-13,May-13}>}sales)


like so on for remaining



Regards

Hemanth


1 Solution

Accepted Solutions
hemanthaanichet
Creator III
Creator III
Author

Hi ,

Finally I solved  .

Thank Sunny for your helpful Ideas,Suggestions and Trick work

Here is the expression:

((above(rangesum(below(sum({<Year=,Month=,YearMonth ={"$(='>=' & Date(AddMonths(Max(YearMonth), -13), 'MMM-YY') & '<=' & Date(Max(YearMonth), 'MMM-YY'))"}>}Sales),0,3)),2))

/

(above(rangesum(below(sum({<Year=,Month=,YearMonth ={"$(='>=' & Date(AddMonths(Max(YearMonth), -25), 'MMM-YY') & '<=' & Date(AddMonths(Max(YearMonth), -12), 'MMM-YY'))"} >}Sales),0,3)),14)))-1


Regards

Hemanth

View solution in original post

1 Reply
hemanthaanichet
Creator III
Creator III
Author

Hi ,

Finally I solved  .

Thank Sunny for your helpful Ideas,Suggestions and Trick work

Here is the expression:

((above(rangesum(below(sum({<Year=,Month=,YearMonth ={"$(='>=' & Date(AddMonths(Max(YearMonth), -13), 'MMM-YY') & '<=' & Date(Max(YearMonth), 'MMM-YY'))"}>}Sales),0,3)),2))

/

(above(rangesum(below(sum({<Year=,Month=,YearMonth ={"$(='>=' & Date(AddMonths(Max(YearMonth), -25), 'MMM-YY') & '<=' & Date(AddMonths(Max(YearMonth), -12), 'MMM-YY'))"} >}Sales),0,3)),14)))-1


Regards

Hemanth