Limit values in a listbox

[#1]

Hi Everyone,

I would like to restrict listbox values based on conditions for more than one field.

Please help.

Thanks

[sunny_talwar]

What are the conditions? May be use an if statement....

[its_anandrjs]

Did you mean the condition is based onthe 2 or 3 fields then you can try this ways on the list box with if condition

Ex:-

=If( Product = 'Product A' and Year = 2016, Category)

Or please elaborate more on the requirement

Regards

Anand

[#4]

I already have this condition:

=aggr(only({<Campaign={'Business Banking Floor Referral','Business Banking Inbound','Business Banking Wealth Collaboration Leads','FNB Business Banking Call Me Back – Lead Apply','FNB Phone App Lead: Business Call Me Back',

             'FNB.Mobi - Business Account','FUSION - BUSINESS ACCOUNT REFERRAL','Lead FNB HR mobi Business','SSA Business Application Lead - CIS Profile Issue','SSA_BUSINESS_CALLBACK','WEBCallBackMultiMembers',

             'SSA Business Application Lead - Exit Call Me Back','SSA Business Application Lead - Force Referral','SSA Business Application Lead - SSA Completion'}>}Campaign),Campaign)

But I also want to add another one : Source_={'Business Bank'}

[rubenmarin]

Hi Moses, the code between '{<' and '>}' is called "set analysis", it's a way to set filters to a field, in that part there are fields separated with commas and the values assigned to each field betwee '{' and '}' (many values are checked as an OR, so the field can have any of those values), so you just add a new field:

=aggr(only({<Campaign={'Business Banking Floor Referral','Business Banking Inbound','Business Banking Wealth Collaboration Leads','FNB Business Banking Call Me Back – Lead Apply','FNB Phone App Lead: Business Call Me Back',

            'FNB.Mobi - Business Account','FUSION - BUSINESS ACCOUNT REFERRAL','Lead FNB HR mobi Business','SSA Business Application Lead - CIS Profile Issue','SSA_BUSINESS_CALLBACK','WEBCallBackMultiMembers',

            'SSA Business Application Lead - Exit Call Me Back','SSA Business Application Lead - Force Referral','SSA Business Application Lead - SSA Completion'}, Source_={'Business Bank'}>}Campaign),Campaign)

The set analysis filters 2 fields: Campaign and Source_

[#6]

I already have this condition:

=aggr(only({<Campaign={'Business Banking Floor Referral','Business Banking Inbound','Business Banking Wealth Collaboration Leads','FNB Business Banking Call Me Back – Lead Apply','FNB Phone App Lead: Business Call Me Back',

             'FNB.Mobi - Business Account','FUSION - BUSINESS ACCOUNT REFERRAL','Lead FNB HR mobi Business','SSA Business Application Lead - CIS Profile Issue','SSA_BUSINESS_CALLBACK','WEBCallBackMultiMembers',

             'SSA Business Application Lead - Exit Call Me Back','SSA Business Application Lead - Force Referral','SSA Business Application Lead - SSA Completion'}>}Campaign),Campaign)

But I also want to add another one : Source_={'Business Bank'}