3 Replies Latest reply: May 19, 2017 5:15 AM by Marcus Sommer RSS

    Select value from customer listbox

    kenny a

      Hi gurus

       

      i have a customer listbox let say

       

      valuelist(1,2,3,4,5)

       

      how to get the value from this customer listbox in text object ?

       

      thanks

        • Re: Select value from customer listbox
          Marcus Sommer

          If you have a real field you could get these values per concat() or getfieldselections() - by using such a calculated dimension without a connection to the datamodel I don't think it will be possible. Maybe if you elaborate it a bit more thereare other ways to reach your aim.

           

          - Marcus

            • Re: Select value from customer listbox
              kenny a

              Hi Marcus,

              let say i have a listbox with express : Valuelist(1,2,3,4,5), then once user click on 1, then

              the pivot table will take this as a parameter ,  so the table express will

               

              10 *  <Value select from the listbox>

               

              Can do it without load script ??

               

              Thank you for your help

                • Re: Select value from customer listbox
                  Marcus Sommer

                  If you instead of the valuelist() takes the content of a small inline table for the listbox, like:

                   

                  load * inline [

                  F2

                  1

                  2

                  3

                  ];

                   

                  you could easily refer to those selections, for example:

                   

                  sum({< F1 = p(F2) >} AnyValue)

                   

                  Another approach would be to use a variable within an inputbox (maybe with predefined values in a dropdown) to which your pivot could refer - but to a valuelist() I don't know any way.

                   

                  - Marcus