Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I need to calculate growth rate of sales compere last 3 month to previous 3 month.
I don't Have Date field I only have Month and year. How to calculate Certain period of month? like between last 6 and 3 month and e.t
Can you share your data or sample application?
Thanks.
You can use the monthstart function and create a month start date.
You can use this date for your rolling calculations.
Find the resources to create a rolling calculation here: The As-Of Table
You can find different methods to calculate the rolling n-months in this post
Calculating rolling n-period totals, averages o... | Qlik Community
It Is Really helpful Thank You Very Much