Is possible to use alternate States with set analysis

[bruno_m_santos]

Hello,

I'm new with alternate states.

It's possible to use alternate states (ie use Group1) with a set analysis syntax as below? Can you give a sample please?

=Count({$<MonthID = {"<=$(=Max(MonthID))"},
Date = {"<=$(=Max(Date))"},
Year = {$(=Max(Year))},
Quarter = ,
Period = ,
[Period (#)] = ,
Month = >}Operacoes_DetalheKey)

Many Thanks

Bruno

[CELAMBARASAN]

Hi,

     Try with this

=Count({Group1<MonthID = {"<=$(=Max(MonthID))"},

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

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

Quarter = ,

Period = ,

[Period (#)] = ,

Month = >}Operacoes_DetalheKey)

Celambarasan

[agilos_mla · Accepted solution]

Hi, Here is a sample of set analysis syntax with alternate states. Use [State Identifier] and ::

Function({[state_identifier1] <field_name2= [state_identifier2]::field_name3>}field_name)

Set values for field_name2 within [state_identifier1] basedon values of field_name3 in [state_identifier2]

e.g. sum({Group1}  <Year=$::Year> Sales)

e.g. avg({MarketDev} <Year={BaseLine}::Year,Category={Global}::ProductCategory>SalesLeadTime

Achieving the same thing with 2 differentsyntax:

Option 1 - sum({[Group 1]<Region =$::Region, [Sales Rep] = $::[Sales Rep], Path = $::Path, Year= $::Year, Quarter = $::Quarter, Month = $::Month>} Sales)

Option 2 - sum({$<[Product Sub Group]= [Group 1]::[Product Sub Group] >} Sales)

Hope that helps,

Michael

[bruno_m_santos]

Thanks Michael,
Your tip was very helpful.
Can you just clarify for me what would I use the syntax described in option 1.
Bruno

[CELAMBARASAN]

Hi,

     $:: is to use the selection in the default state filters.instead of $ you can specify the group name to synchronize with it

     Can you tell me what your trying to achieve?

Celambarasan

[bruno_m_santos]

Hi Michael,

I'm just trying to understand the logic, because i'm debugging the reason why I have different results for the alternate state (Group1) of what I have without using the "alternate state" but simulating the same conditions.

I'll update this forum.

Thanks

Bruno

[#7]

I'm trying to follow some of Michael's examples, but I'm getting errors in the "::" and "$::" syntax.   I've tried playing around with all the examples above but am still not successful. 

I have a measure (Sales), and I've created two Groups (Group1 and Group2), both are there to select/compare date ranges).  I want to be able to select other filters/list boxes and also have them apply to the Bar chart...I've made those other list boxes alternate states, too (for example: variable Partner I called Partner1...variable Channel I've named Channel1, etc.).  I'm trying to figure out how to get those alternate states into the Sales expression.

Any more samples or logic/concepts that can help me?  Thanks!

[lorenwood]

Thanks this really helped, Loren

[#9]

Use the syntax with the [ ] brackets

=(SUM(  { State1Name < [Field1]=[State2Name]::Field1>} Sales )

Ran into the same problem with the curly braces { }

Rgds

[#10]

Hi Michael,

I have tried this but in my sample application, I am not getting how is my thired expression's output is coming (need some explanation on it).

PFA for my sample App. And it will be great if you explain your other options too.

Thanks in Advance!!!

-Yojas