Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Prior Quarter with Fiscal Calendar

Is it possible to create a chart showing sales for a Prior Fiscal Quarter?

I know how it is done with a standard calendar but the scripting doesn't work when you apply it to a fiscal calendar.  I can set up a variable that will calculate the previous quarter as well, however, when I select Quarter 1 it wants to try and display Quarter 0 instead of quarter 4 of the previous fiscal year.

Thanks,

1 Reply
Not applicable
Author

Chris,

Can you try this.

May be you need to write a case logic to check if your previous quarter & current quarter are in same year, then consider previous quarter else return null() & in chart dimension properties suppress null.

Thanks

Brad.