Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am facing issue at Set analysis to get previous quarter [max(Quarter)-1] data when we select Quarter [max(Quarter)].
I have data format (YYYYMM) from that I derived Year (YYYY), Quarter(Q1) and YearQtr (YYYYQ like 20191..) fields.
Written expressions in chart as below:
Sum({<YearQtr = {$(vPreviousQtr)}} Sales) - tried single, double and no quotations at variable.
VPreviousQtr = If(Right(YearQtr) = 1, YearQtr-7, YearQtr-1) = It will show previous quarter.
And I tried with "autoCalendar" as well to get date fields.
I used "QuarterAgo" field in set analysis instead of YearQtr which has Quarter Numbers (starting with 0 like current quarter is '0'.
App has only Year and Quarter filters to select by users.
With above to ways i could not get previous quarter data by selected Quarter [max(quarter)].
Could you please assist with if you have any idea.
Thanks, Nihhal.
Nihal,
Say your max quarter is 20191 (YYYYQ - as you mentioned). Now you try to get the previous quarter from this probably by simply subtracting 1 something like : Max(Quarter)-1. Then what do you get ? It's 20191-1 = 20190. However, you expected the previous quarter, i.e. - 20184 . So that's the catch.
Hi Tresesco - thanks for your response.
I am using below srcript to get previous quarter same mention in my question.
VPreviousQtr = If(Right(YearQtr) = 1, YearQtr-7, YearQtr-1) = It will give previous quarter.
Sorry, somehow I missed that you mentioned in your post above.
You meant:
VPreviousQtr = If(Right(YearQtr, 1) = 1, YearQtr-7, YearQtr-1) right?
Yes.
I believe that something went wrong while passing variable or hard coded in set analysis.
So this resolved your issue...or still persists. If not resolved, could you share a sample app or few screenshots showing the issue?
Hi Tresesco, i could not copy screen shots from client sever/rdp and still not resolved issue.
Issue at set analysis as i mention in question there is any mistake in script? (set analysis) i did not see any error message but it is not working at chart or text box objects.