topic Passing variable - Set Analysis in App Development

Passing variable - Set Analysis

h2k18 — Sat, 16 Nov 2024 20:02:19 GMT

Hi,

I have created the following variable to be utilized in the set analysis calculation:

vCurrQTR = 2018Q4 (User selected)

Variable Name: vTestQTR

=if(right(vCurrQTR,2) = 'Q4',
chr(39)&left(vCurrQTR,4)&''&'Q1'&chr(39)&chr(44)&
chr(39)&left(vCurrQTR,4)&''&'Q2'&chr(39)&chr(44)&
chr(39)&left(vCurrQTR,4)&''&'Q3'&chr(39)&chr(44)&
chr(39)&left(vCurrQTR,4)&''&'Q4')&chr(39)

If we evaluate the above variable (=vTestQTR) in Text & image object it will yield the following result: '2018Q1','2018Q2','2018Q3','2018Q4'

Currently:
sum({<PERIOD_TYPE = {'Q'},RETURN_TYPE = {'S'},PERIOD = {'2018Q1','2018Q2','2018Q3','2018Q4'}>}Return) gives the correct result.

Now using variable would like to replace the above highlighted condition and get the same result. Unfortunately the variable is not working as expected inside the set analysis expression. Can you help with the correct syntax?
sum({<PERIOD_TYPE = {'Q'},RETURN_TYPE = {'S'},PERIOD = {'variable'}>}Return)

Thanks.

Re: Passing variable - Set Analysis

sunny_talwar — Fri, 20 Sep 2019 16:17:41 GMT

Try one of these two options

Sum({<PERIOD_TYPE = {'Q'},RETURN_TYPE = {'S'},PERIOD = {"$(vTestQTR)"}>} Return)

Sum({<PERIOD_TYPE = {'Q'},RETURN_TYPE = {'S'},PERIOD = {"$(=$(vTestQTR))"}>} Return)

Re: Passing variable - Set Analysis

h2k18 — Fri, 20 Sep 2019 16:22:25 GMT

Thanks for the response. When i tried them its gives me no result.

Re: Passing variable - Set Analysis

sunny_talwar — Fri, 20 Sep 2019 16:27:03 GMT

Would you be able to share a sample where we can see the issue?

Re: Passing variable - Set Analysis

h2k18 — Wed, 25 Sep 2019 21:25:36 GMT

Sure. The sample file is attached.

Re: Passing variable - Set Analysis

sunny_talwar — Mon, 30 Sep 2019 12:46:21 GMT

Try this

if(RETURN_TYPE = 'R', Sum({<PERIOD = {$(=$(vTestQTR))}, PERIOD_TYPE = {'Q'}, RETURN_TYPE = {'R'}>} RETURN), if(RETURN_TYPE = 'S', Sum({<PERIOD = {$(=$(vTestQTR))}, PERIOD_TYPE = {'Q'}, RETURN_TYPE = {'S'}>} RETURN), if(RETURN_TYPE = 'T', Sum({<PERIOD = {$(=$(vTestQTR))}, PERIOD_TYPE = {'Q'},RETURN_TYPE = {'T'}>} RETURN) )))