topic Re: Use Alternate state selection in common filter in App Development

Use Alternate state selection in common filter

Cbhuvi27 — Fri, 15 Nov 2024 21:03:57 GMT

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.

Re: Use Alternate state selection in common filter

Antoine04 — Thu, 15 Feb 2024 12:49:26 GMT

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

Re: Use Alternate state selection in common filter

Cbhuvi27 — Thu, 15 Feb 2024 13:19:21 GMT

Hello Antonie,

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

Re: Use Alternate state selection in common filter

Antoine04 — Thu, 15 Feb 2024 13:28:12 GMT

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

Re: Use Alternate state selection in common filter

Cbhuvi27 — Thu, 15 Feb 2024 13:44:23 GMT

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

Re: Use Alternate state selection in common filter

Antoine04 — Thu, 15 Feb 2024 13:49:37 GMT

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)

Re: Use Alternate state selection in common filter

Cbhuvi27 — Thu, 15 Feb 2024 13:52:06 GMT

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

Re: Use Alternate state selection in common filter

Antoine04 — Thu, 15 Feb 2024 13:55:38 GMT

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)

Re: Use Alternate state selection in common filter

Cbhuvi27 — Thu, 15 Feb 2024 14:25:21 GMT

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.

Re: Use Alternate state selection in common filter

Antoine04 — Thu, 15 Feb 2024 15:21:31 GMT

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 !

Re: Use Alternate state selection in common filter

Cbhuvi27 — Thu, 15 Feb 2024 16:08:17 GMT

Sorry for multiple questions, but will this not decrease the performance of sheet ?

Re: Use Alternate state selection in common filter

Antoine04 — Thu, 15 Feb 2024 16:14:15 GMT

It might. But I don't see other solution except what I gave you.