Set Analysis + Pass strings

[Anonymous]

Hi,

In the Dashboard I have a multi box which has following values

A

B

C

D

E

now based on the selection I need to pass value to set analysis expression

Lets Say if I select A and B then the expression should be

=Sum({<ColumnValue={'A','B'}>} Amount)

if I select A ,B and C then the expression should be

=Sum({<ColumnValue={'A','B','C'}>} Amount)

[Gysbert_Wassenaar]

If the field in the multibox is ColumnValue then you don't need any set modifier. sum(Amount) will do what you want. If it's a different field then use =Sum({<ColumnValue=P(MultiBoxFieldHere)>} Amount) and replace MultiBoxFieldHere with the name of the field in the multibox. And it has to be a field, expression do not work.

[tresesco]

That is same as simple = Sum(Amount)  // only the selected values would be considered, isn't it?

[abhijain]

Hi Manoj,

Create 1 variable eg 

v_var = getfieldselections(ColumnName,',')

and use this expression in chart

sum({$<ColumnName={$(v_var)}>}Amount)