topic Show Previous Quarter data in Table Chart in App Development

Show Previous Quarter data in Table Chart

nihhalmca — Mon, 20 Dec 2021 21:38:40 GMT

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.

Re: Show Previous Quarter data in Table Chart

tresB — Mon, 16 Dec 2019 10:25:17 GMT

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.

Re: Show Previous Quarter data in Table Chart

nihhalmca — Mon, 16 Dec 2019 10:18:42 GMT

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.

Re: Show Previous Quarter data in Table Chart

tresB — Mon, 16 Dec 2019 10:26:26 GMT

Sorry, somehow I missed that you mentioned in your post above.

You meant:

VPreviousQtr = If(Right(YearQtr, 1) = 1, YearQtr-7, YearQtr-1) right?

Re: Show Previous Quarter data in Table Chart

nihhalmca — Mon, 16 Dec 2019 10:35:23 GMT

Yes.

I believe that something went wrong while passing variable or hard coded in set analysis.

Re: Show Previous Quarter data in Table Chart

tresB — Mon, 16 Dec 2019 10:49:02 GMT

So this resolved your issue...or still persists. If not resolved, could you share a sample app or few screenshots showing the issue?

Re: Show Previous Quarter data in Table Chart

nihhalmca — Mon, 16 Dec 2019 11:29:43 GMT

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.