1 Reply Latest reply: May 13, 2016 12:56 PM by Stefan Wühl RSS

    Same information different charts

    Victor Barradas

      Good day

      I have a question, i am building my application using several Excel spreadsheet that contain exactly the same fields. What i am trying to achieve is the following, the chart on the left must shown total information of all entities and the chart on the right should have only the information of one entitiy.

      Obviuosly as you can see both have the same info everytime i select something.

      Please help

      Thanks in advance

       

      Charts.jpg

        • Re: Same information different charts
          Stefan Wühl

          If I understood correctly, create a field when loading your Excel files that identify your source:

           

          LOAD

              'A' as SOURCE,

               FieldA,

               FieldB,

               ...

          FROM YourExcelFile_A.xls;

           

          LOAD

               'B' as SOURCE,

               FieldA,

               FieldB,

               ...

          FROM YourExcelFile_B.xls;

           

          ...

           

          [Just a demo, you don't need to explicite repeat the LOAD statements, if you can make the Source definition dynamic, e.g. by parsing FileName() ]

           

          Then use a filter in your second chart to limit the records to one source (e.g. B), like

           

          Sum({<SOURCE= {'B'}>} FieldA)

          Sum({<SOURCE= {'B'}>} FieldB)