6 Replies Latest reply: Nov 20, 2013 1:37 AM by Sibin Jacob.C C RSS

    chart

      Hi,

       

      how to make expression value as input value as i attachment in straight table.

        • Re: chart

          Hi,

             If I understand your question correctly then follow these steps:

          1. Create one variable and write Allocation field expression on that (which you wrote in straight table).

          2. Add input box object and set created variable on it.

          3. Now whenever you change your filter, input value will also change as expression value.

           

          Hope this will help you

           

          Regards,

          Ashutosh

            • Re: chart

              Hi,

               

              I need to enter the values to the table box manually.for this i am using 'INPUTFIELD' fields .when i am using this the expression is not working.i need both requirement .please find the attachment .and help me out this

            • Re: chart
              Sibin Jacob.C C

              HI Ramesh,

               

              Please find the attached application.I used a input filed to enter the values inside a straight table and calculate based on the inputs.

               

              Please let me know if you need any additional details.

               

              Thanks,

              Sibin Jacob.C

                • Re: chart

                  Hi,

                  This is my contact number 8746078764......

                  Please provide me the contact no....i have some doubts

                  • Re: chart

                    Hi sibin,

                     

                    I am using personal edition.so,please tell me how u did,or attachment word doc or any code

                     

                    Thanks very much

                     

                    Ramesh

                      • Re: chart
                        Sibin Jacob.C C

                        Hi Ramesh,

                         

                        Sorry for replying so late, I was on a vacation. Please find below the script and expression.

                         

                        Qualify*;
                        INPUTFIELD Data.Test;

                        Directory;
                        Data:
                        LOAD Produc_Name,1 as Test,Product_Values
                        FROM
                        Test.xlsx
                        (
                        ooxml, embedded labels, table is Sheet1);

                         

                        Dimension is Data.Product_Name and expression is InputSum(Data.Test)

                         

                        My contact number - 08951307704

                         

                        Thanks,

                        Sibin Jacob.C