Help with Set Analysis!!!

[educastri83]

Hello community !!


I have a problem I think it's easy but I can not find the solution.


I'll want to create a KPI using a " Text Box " simple expression is:


= Sum ( { < Indicators = ' Economic Value Added ' } > } USD )


You see I have a dimension called "Indicators" but I just want the KPI to show that the result of the indicator ' Economic Value Added '


All good there, the difficulty I have is when I want to apply Set Analysis with variables as vSetQTD , vSetYTD etc .. ..

I don't know like writing the expression. Normally I would with

= Sum ( { < $ ( vSetYTD ) > } USD )


How do I get back my previous expression but only of my indicator " Economic Value Added '


Thank you very much , I think it is simple but I've been mulling over time .


Eduardo

[sunny_talwar]

May be like this?

=Sum({<Indicators = {'Economic Value Added'}, $(vSetYTD)>} USD)

[saimahasan]

what is the value of the variable $ ( vSetYTD ) ??

[susovan]

Hi,

Add this '{' in your expression.

I think it should be work.

= Sum ( { < Indicators = {' Economic Value Added ' } > } USD )

[Anonymous]

Hi Eduardo,

I suggest you to write it like a function:

Create a variable like this:

SUM({<$($1),Indicators = {'$2'}>},$3)

On text box:

= $(YourVarName(SetAnalysisYTDVarName,IndicatorFieldValue,FieldToSum)

With this you can write all your KPIs with only one variable.

Regards!

[VishalWaghole]

Expression could be depend on what value stored in variables $(vSetQTD) , $(vSetYTD).

Please let us know variables details.

- Regards,

Vishal Waghole

[educastri83]

it Works!!!!! thank a lot Sunny

[educastri83]

Ok!! You're Right! Thanks

[educastri83]

Hi Saima!

It's =

PeriodID = {"<=$(=Max(PeriodID))"},

Year = {$(=Max(Year))},

Quarter = ,

Half = ,

Month = ,

Period =

Works pecfect with Sum({<Indicators = {'Economic Value Added'}, $(vSetYTD)>} USD)

[educastri83]

Perfect!!! Manuel

It Works, much better into a new variable

Thanks