5 Replies Latest reply: Nov 15, 2016 8:40 AM by Moses Zwane RSS

    Limit values in a listbox

      Hi Everyone,

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

      Please help.

       

      Thanks

        • Re: Limit values in a listbox
          Sunny Talwar

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

            • Re: Limit values in a listbox

              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'}

                • Re: Limit values in a listbox
                  Ruben Marin

                  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_

              • Re: Limit values in a listbox
                Anand Chouhan

                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

                  • Re: Limit values in a listbox

                    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'}