Area for people to learn more about current Qlik related job postings.
Foe the fiscal year how to find previous three month average sales growth using pivot table.
Would you be able to share a sample?
I don't try to accomplish this with set expressions. I use a data-drive approach. You should be using a time dimension.
I've created a script called QlikRTP which can be used to make your life easier. You can read about it in my post, here.
RTP stands for Relative Time Periods. This script leverages your existing month dimension to add the following relative time elements to your app:
Not only that, these RTPs will work for any anchor month! (not just the current period)
This approach greatly simplifies your measures by only requiring two set modifiers.