Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi in the edit script iam defining a variable and the part of date is below
''Aggr(Only({$<Date = {">=$(StartDate)<=$(EndDate)"}
you see after the execution in the front end when i take the variable into a input box and i see that the $ is changed to ==
and when i edited the variable in the script like below
''Aggr(Only({$<Date = {">=@(StartDate)<=@(EndDate)"}
now the out put is also coming like @ it shoul show me $ only ..
Set analysis does not work in script level
Go with the If condition and Aggr() function alos does not work in script you need to convert this into it using the
Group by clause
Why you need this in Script instead of Set Operator.
May be try with Where condition of end of the script of that load source
Declare like the following
let x='Aggr(Only({$'&'<Date = {">=$'&'(StartDate)<=$'&'(EndDate)"}';
hth
Sas