6 Replies Latest reply: Mar 27, 2014 7:08 AM by AVIRAL NAG RSS

    GetPossibleCount() Example

    AVIRAL NAG

      Hi Community

       

      Can anybody gave me the Example of GetPossibleCount() with Attachment.

       

       

      Regards

      Aviral Nag

        • Re: GetPossibleCount() Example
          Jagan Nalla

          Hi,

           

          if you have sales data for different countries.

           

          For eg:

          CountrySalesData
          India200
          India400
          US100
          US50
          US20

           

          Now when you select India from country and in text object if you place GetPossibleCount(SalesData) it returns 2. B'coz we have 2 possible values for India. If you clear it will give 5

           

          Thanks,

          Jagan

            • Re: Re: GetPossibleCount() Example
              AVIRAL NAG

              Can you help me in the Attached Scenario.

                • Re: Re: Re: GetPossibleCount() Example
                  Tresesco B

                  Use show condition expression (layout tab) like:

                  SubStringCount(Concat(Level,';'),'1') -- for Level 1

                  SubStringCount(Concat(Level,';'),'2') -- for Level 2

                  ...

                  PFA

                  • Re: Re: Re: GetPossibleCount() Example
                    Jagan Nalla

                    Hi,

                     

                    You can't use expression in getpossiblecount, we can use only fieldnames. Please try to convert all your expressions into script level. As below,

                     

                    Test:

                    LOAD emp_name AS EmpID,

                         emp_name AS Name,

                         superior AS [Reporting To],

                         emp_sub_department AS Department,

                         emp_code,

                         emp_location

                      

                    FROM

                    [C:\Users\CIPL-BIAdmin\Desktop\Canon Hierarchy\Sample\Sampletestttt.xlsx]

                    (ooxml, embedded labels, table is Sheet1);

                     

                     

                    Hierarchy:

                    Hierarchy (EmpID,[Reporting To],Name,Manager,Name,EmpTree,'/',Level)

                    LOAD *

                    RESIDENT Test;

                    DROP TABLE Test;

                     

                     

                    LOAD EmpID,

                    if(Level=1,Name&chr(13)&emp_location&chr(13)&Department) as Level1,

                    if(Level=2,Name&chr(13)&emp_location&chr(13)&Department) as Level2,

                    if(Level=3,Name&chr(13)&emp_location&chr(13)&Department) as Level3,

                    if(Level=4,Name&chr(13)&emp_location&chr(13)&Department) as Level4

                    Resident Hierarchy;

                    - Now add Level1 into listbox and in listbox properties -> Layout -> Show (enable conditional) and paste this exp =if(GetPossibleCount(Level1)>0,True(),False())

                    - Repeat this step for other listboxes by changing the expression. i.e. instead of Level1 use Level2, Level3 and Level4

                     

                    Hope it helps you

                     

                    Cheers!!!

                    Jagan