topic Re: setting a variable with set analysis in back end code in Management & Governance

setting a variable with set analysis in back end code

Hope_AA — Wed, 20 May 2020 16:23:31 GMT

I'm trying to add the function below as a variable to my code instead of master measure but it keeps giving me errors. I tried breaking it up and using the variables but it's still not working. Can anyone help me?

sum(aggr(count({<Rprtd_Flag={'Y'}>} Distinct UniqueKey),[Service Date]))

thanks a lot..

Re: setting a variable with set analysis in back end code

Gui_Approbato — Wed, 20 May 2020 16:28:12 GMT

I think you're missing some parenthesis or so ( assuming that Y is your variable)..

Try :

sum(aggr(count({<Rprtd_Flag={'$(Y)'}>} Distinct UniqueKey),[Service Date]))

sum(aggr(count({<Rprtd_Flag={'$(=Y)'}>} Distinct UniqueKey),[Service Date]))

Re: setting a variable with set analysis in back end code

sunny_talwar — Wed, 20 May 2020 16:51:01 GMT

What error do you get?

Re: setting a variable with set analysis in back end code

Hope_AA — Wed, 20 May 2020 16:59:18 GMT

Unexpected Token....

see below

Re: setting a variable with set analysis in back end code

sunny_talwar — Wed, 20 May 2020 17:03:11 GMT

Oh, you are trying to store this expression into a variable within the script? May be try SET like this

SET Cnt_All_Unique = Sum(Aggr(Count({<Rprtd_Flag = {'Y'}>} DISTINCT UniqueKey), [Service Date]));

Re: setting a variable with set analysis in back end code

Hope_AA — Wed, 20 May 2020 17:10:37 GMT

sorry maybe I didn't explain well but yes, that's the whole code for this part which is still creating the same error.

SET Cnt_All_Unique = Sum(Aggr(Count({<Rprtd_Flag = {'Y'}>} DISTINCT UniqueKey), [Service Date]));
let Cnt_All_Unique= $(Cnt_All_Unique);

Re: setting a variable with set analysis in back end code

squeakie_pig — Wed, 20 May 2020 17:12:01 GMT

It's probably not liking the single quotes in your set analysis {'Y'}. You need to break it up and use chr(39) instead.

= 'sum(aggr(count({<Rprtd_Flag={' &chr(39) &'Y' &chr(39) &'}>} Distinct UniqueKey),[Service Date]))'

Re: setting a variable with set analysis in back end code

Hope_AA — Wed, 20 May 2020 17:20:32 GMT

That was it... thank you so much.

Really appreciate all your help both of you.