Use Alternate state selection in common filter

[Cbhuvi27]

Hello All,

I have few filters in which 2 of those have alternate state applied and other ones are common. Now how to make selection made in alternate state to be applied in normal one and vice versa.

[Antoine04]

Hello,

You need to use the name of your alternative state in your expression.

For example if your alternate state is called S1, then you can have :

Sum({S1} Sales) : that will give you the sales for the S1

Sum(Sales) : that will give you the sales for all your data

Sum({S1*$} Sales) : that will mix the both

Best Regards,

Antoine L

[Cbhuvi27]

Hello Antonie,

Thanks much for your reply, but I want to apply multiple alternate state on other filters and not one measures.

[Antoine04]

I don't get it. You want the "normal" filterpane to be filter according to the selections of your S1 ?

Can you give a concrete example ?

Thanks

[Cbhuvi27]

Partially Yes, the normal filterpane should get filterred based on the selections of S1,S2 and S3

aggr(only({[S1],[S2],[S3]}City),City)

I am using above query to apply multiple alternate states on the City but its not working in this way

[Antoine04]

OK I get it, so I have this :

And if I filter in my S1 on Beers, I then have this :

Boissons = Drinks

And here is the formula in the filter pane : 

=If(WildMatch('$(=Concat({Site1} Rayon,'|'))','*'&Rayon&'*'), Rayon)

[Cbhuvi27]

So you applied S1 on categories ? if so then yes, here we have only one State that is S1 but I wanted to apply for 3 Alternate state

[Antoine04]

Yes, it's working with multiples alternates states :

You need to modify the formula like this in the filterpane: 

=If(WildMatch('$(=Concat(distinct{Site1+Site2} Rayon,'|'))','*'&Rayon&'*'), Rayon)

[Cbhuvi27]

Hello Antonie, this is working only if I select something in all three states. If I am doing for one filter with Alternate state its not working.

[Antoine04 · Accepted solution]

OK, I got it :

So what you need is :

• One variable named Site1 : =If(Not IsNull(GetCurrentSelections(' | ', ':', ',' , 1, 'Site1')),'Site1+','')

• One variable named Site2 : =If(Not IsNull(GetCurrentSelections(' | ', ':', ',' , 1, 'Site2')),'Site2+','')

Then, it should work using them like this in the filterpane :

=If(WildMatch('$(=Concat(Distinct {$(=Coalesce(Left('$(Site1)$(Site2)',Len('$(Site1)$(Site2)')-1),'$'))} Rayon,'|'))','*'&Rayon&'*'), Rayon)

It works for me !