Discussion board where members can get started with QlikView.
I need to calculate the rolling quarter incremental share values against YearMonth & Brand
Note: Need show to latest 12 months
(Current Year RQTR Sale / Current Year RQTR Total Sale)
(Previous Year RQTR Sale / Previous Year RQTR Total Sale)
CY : Latest 12 months i.e.,(Aug-15 to Jul-16)
PY : Previous latest 12 months i.e.,(Aug-14 to Jul-15)
Jul- 16 = sum of sale value of May-16,Jun-16,Jul-16 against the brands
Jun-16 = sum of sale value of Apr-16,May-16,Jun-16 against the brands
like that for remaining months so on....
I got the values for current year rolling quarter values
but i was struck in getting the previous year rolling quarter values
Attached my Sample data and QVW
Go to Solution.
finally I solved my requirement
Pls find the attachment may be it may helpful
Don't you just want to do the same as yoru current RQTR calendar but change your add months to -12 ?
I might not be getting exactly what you're trying to do here
i already tired it but there is an issue with plotting the values
when i did subtract current year RQTR with previous year RQTR
the values are not plotted exactly in latest 12 months instead of that it is plotted latest 24 months
which is not my requirement