Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone!
I am looking to create a bar chart showing month on month growth rates. I would like to see cumulative growth month on month along with a trend line so that the period where sales went down could be easily extracted, for the respective product. Please let me know how I can achieve this?
Best Regards,
Rony
Doesn't look right to me. For example 2017 Jan is 10, Feb is 20 and Mar is 30.... but YTM17 Jan is 10, Feb is 30 and Mar is 30? Why not 60? I don't think you are taking enough time to prepare a sample. If you want good answers, please spend good time on preparing a sample.
Below is an updated image.
I am sorry about that. I have attached a new sample image.
Correctly calculated sample data below.
Something like this should work
RangeSum(Above(Sum(Measure), 0, Month))
/
Aggr(Above(RangeSum(Above(Sum(Measure), 0, Month)), 12), MonthYearField)
Sunny,
Could you explain the expression? What is supposed to come in "Month" and "MonthYearfield"?
Month is a field which is your dimension... J, F, M, A... etc. created in the script like this Month(DateField) as Month.
MonthYear is a field which will include month and Year information and can be created in the script like this Date(MonthStart(DateField), 'MMM-YYYY') as MonthYear
RangeSum(Above(Sum(Measure), 0, Month)) is accumulating current year
Aggr(Above(RangeSum(Above(Sum(Measure), 0, Month)), 12), MonthYearField) is accumulating the last year
Does this help?
I have not created a cumulative field in my actual data. Do I need to create that. I apologize I am unable to understand how this formula would work.
Please look here for me to help you better
Qlik Community Tip: How to Get Answers to Your Post
Preparing examples for Upload - Reduction and Data Scrambling
Hi Sunny,
I did understand. Let me try this and get back to you. Thanks a lot Sunny.
Rony