topic Re: How to create a new filter based on another filter values in App Development

How to create a new filter based on another filter values

SatyaPaleti — Sat, 16 Nov 2024 18:26:13 GMT

Hi Everyone,

I have small issue can you please help me to resolve this Issue.

I have following countries in field Country

1. India

2. U.S.A

3. Brazil

4. Europe

5. England

6.Malaysia

I need to Create a new field based on these countries. Field name is Country Category

so if country India, Brazil, U.S.A then we have to show Category A

so if country Europe, England, Malaysia then we have to show Category B

If all the Countries it should be Categories ALL

in Country Category Field i will have 3 Values Category A, Category B & Category ALL.

if User selects Category A then in the filter Country Only India, Brazil, U.S.A should select

if User selects Category B then in the filter Country Only England, Europe, Malaysia should select

if User Selects Category ALL then all the Countries should select

I have written like below

if( Country = 'India' or Country = 'Brazil' or Country = 'U.S.A', 'Category 1',

if( Country = 'England' or Country = 'Europe' or Country = 'Malaysia', 'Category 2', 'Category ALL'))

but I am getting only Category A & Category B in filter. Can some one suggest how to Include Category ALL also

Thanks and Regards,

Satya

Re: How to create a new filter based on another filter values

tresB — Mon, 29 Jun 2020 05:23:08 GMT

For 'All' you need to reload the country field one more time. Try like:

t1: Load *, If(Match(Country, 'India', 'China'), 'Asia', if(Match(Country, 'UK', 'FRA'), 'Europe', 'USA')) as Continent Inline [ Country India, USA UK China FRA ]; Load Country, 'All' as Continent Resident t1;

Re: How to create a new filter based on another filter values

SatyaPaleti — Mon, 29 Jun 2020 06:23:28 GMT

Hi Treseco,

Thank you so much for your response but the above requirement is different

Thanks and Regards,

Satya

Re: How to create a new filter based on another filter values

tresB — Mon, 29 Jun 2020 06:38:24 GMT

@SatyaPaleti wrote:
Thank you so much for your response but the above requirement is different

Would you mind explaining a bit more ? If you have tried the solution I proposed - please try to explain the differences in it's light.

Re: How to create a new filter based on another filter values

SatyaPaleti — Mon, 29 Jun 2020 07:08:58 GMT

Hi Tresco,

I need to create a filter based on Countries.

I have 6 Countries

1. India

2. USA

3.England

4. Brazil

5.Malaysia

6. Europe

if I click on Category A then India, USA & England should select

if I click on Category B then Brazil, Malaysia & Europe should select

If i click Category C then all the countries should select

Thanks and Regards,

Satya

Re: How to create a new filter based on another filter values

tresB — Mon, 29 Jun 2020 07:37:52 GMT

I guess it is not much different, you just need to change the values with same logic. Try:

t1: Load *, If(Match(Country, 'India', 'USA', 'England'), 'Category 1', if(Match(Country, 'Brazil', 'Malaysia', 'Europe'), 'Category2')) as NewField Inline [ Country India USA England Brazil Malaysia Europe ]; Load Country, 'Category All' as NewField Resident t1;

Re: How to create a new filter based on another filter values

Hakim-A — Wed, 01 Jul 2020 13:52:06 GMT

Hello,

I think you should create these categories in your script and then use buttons + variables to select the groups you want