Set Analysis Explanation

[prees959]

Hi.

Can someone explain what is happening in this expression please:

=sum({<$(vCalendar1),Date=P(Date)>}[all_values])

Many Thanks,

Phil

[sunny_talwar]

It seems that you are ignoring all selection in calendar fields within your dashboard and only looking to see possible Dates with this expression

[prees959]

thank you

[Anil_Babu_Samineni]

It sum the all_values when all possible valuess from Date field and Calendar1 variable. We are not sure, What variable is declare in your environment?

[sunny_talwar]

I think it might be a Concatenated list of fields from the calendar table, but excluding Date field

[prees959]

Hi,

Yes, $(vCalendar1) seems to be a concatenated list of fields.  The above expression isn't working correctly. When I place $(vCalendar1) into a textbox there is an Error: Garbage after expression: ","

The variable is set as  [Year],[MonthYear],[Fiscal Month],[Fiscal Yr],[Main Date]

however the expression has a red underline from [Month Year] to [Main Date].

I have checked that all these fields are available in the data model and they are.

Can you help please?

Phil

[jonathandienst]

>>When I place $(vCalendar1) into a textbox there is an Error: Garbage after expression: ","

That's because $(vCalendar1) is trying to evaluate the list as an expression, which will clearly not work. To see this variable in a text box, just use =vCalendar1 as the expression.

>>however the expression has a red underline from [Month Year] to [Main Date].

For the same reason...

[prees959]

ok,

so should be expression be

=sum({<vCalendar1,Date=P(Date)>}[all_values])  ?

[sunny_talwar]

I think for checking its value in text box you need to just use =vCalendar, but within the set analysis, you might still need dollar sign expansion

=Sum({<$(vCalendar1),Date=P(Date)>}[all_values])

Is this not working?

[prees959]

Hi Sunny,

There is a value in the text box - but when the a date value is selected - it doesnt change - whereas a simple sum(all_values) does change when different dates are selected....