issue in expression

[Chanty4u]

Hi all,   @sunny_talwar

i  have one variable like below.

=vPrevQtr

=chr(39)&concat(DISTINCT(Left(Quarter,4)-1)&Right(Quarter,2),chr(39)&','&chr(39)) & chr(39)

i have used  vPrevQtr in text object  its working fine its giving exact result..    but same varibale  used in  below expression its giving null.  As we have data for that   [its shwoing Expression is OK ]

if(GetFieldSelections(ServiceGroup) = '9R', Sum({$<Quarter={$(vPrevQtr)},Type={'Actuals'}>}Service_Amount),
if(WildMatch(getfieldselections(ServiceGroup),'*9R*'),Sum({$<Quarter={$(vPrevQtr)},Type={'Actuals','SKU'}>}Service_Amount),
Sum({$<Quarter={$(vPrevQtr)},Type={'Actuals'}>}Service_Amount)))

 where im doing wrong>?

Thanks

[vishsaggi]

Can you try quotes around your variable like {'$(vPrevQtr)'} ?

[vikramv]

Try to replace this Quarter={$(vPrevQtr)} with Quarter=$(vPrevQtr) in set analysis.

As you already included the brackets and quotes in a variable ?

[sunny_talwar]

---

@Chanty4u wrote:

Hi all,   @sunny_talwar

i  have one variable like below.

=vPrevQtr

=chr(39)&concat(DISTINCT(Left(Quarter,4)-1)&Right(Quarter,2),chr(39)&','&chr(39)) & chr(39)

i have used  vPrevQtr in text object  its working fine its giving exact result.. 

---

When you say it works in text box object, what exactly do you mean? Can you show an image of what you see in a text box object when you use this?

[Chanty4u]

Vikkyv getting error in set modifier adhoc element list ',' ) expected

[Chanty4u]

Vishsaggi  am getting 0

[Chanty4u]

  Hi @sunny_talwar    when i select   in Quarter field   2019Q1 and 2019Q2    the text box result is  2018Q1,2018Q2   

if i select 2019Q1     result is getting 2018Q1 ...like that

[HirisH_V7]

Hi Suresh,

i just checked its working fine and picking the variables as it should. Even i created an example for the same. Below is screen shot for ref.

i Guess there is some issue pertaining with other data parameters. Try removing them and check quarter alone first. attached is the sample qvw for ref.

HTH,

HirisH

[rubenmarin]

Hi Suresh, I think your variable needs an starting equal sign:
SET vPrevQtr = =chr(39)&concat(DISTINCT(Left(Quarter,4)-1)&Right(Quarter,2),chr(39)&','&chr(39)) & chr(39);

If it's not possible to add the starting equal sign, maybe using the variable as:
Sum({$<Quarter={$(=$(vPrevQtr))}>}Quarter)

[HirisH_V7]

Check this with Half year and year updated.

PFA