Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try to replace this Quarter={$(vPrevQtr)} with Quarter=$(vPrevQtr) in set analysis.
As you already included the brackets and quotes in a variable ?
@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?
Vikkyv getting error in set modifier adhoc element list ',' ) expected
Vishsaggi am getting 0
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
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
Check this with Half year and year updated.
PFA