2 Replies Latest reply: Feb 10, 2014 2:59 PM by Clever Anjos RSS

    Similar tables disturb charts

      The problem I have is following:

      When my script only the following code has...:

       

      "Age Groups Germany":

      LOAD * INLINE [

          Age, "Total Population", "Mobile User (Unique User)"

          14-19, 7.1, 13.3

          20-29, 14.0, 27.7

          30-39, 13.8, 21.4

          40-49, 19.0, 21.7

          50-59, 16.4, 10.0

          60+, 29.6, 5.8

      ];

       

      ... then everything is ok. I can generate my chart the way I want.

      However, when I add to the script the following code:

       

      "Sex Germany":

      LOAD * INLINE [

          Sex, "Total Population", "Mobile User (Unique User)"

          Male, 48.9, 58.7

          Female, 51.1, 41.3

      ];

       

      the diagram that is based on the first table gets messed up.

      Why is that happening and how can I avoid it?

      (I already tried some combinations with QUALIFY and NOCONCATENATE... did not work as I wanted it.,,)

        • Re: Similar tables disturb charts
          Clever Anjos

          Try renaming your fields

          "Age Groups Germany":

          LOAD * INLINE [

              Age, "Total Population by Age", "Mobile User (Unique User) By Age"

              14-19, 7.1, 13.3

              20-29, 14.0, 27.7

              30-39, 13.8, 21.4

              40-49, 19.0, 21.7

              50-59, 16.4, 10.0

              60+, 29.6, 5.8

          ];

          "Sex Germany":

          LOAD * INLINE [

              Sex, "Total Population By Sex", "Mobile User (Unique User) by Sex"

              Male, 48.9, 58.7

              Female, 51.1, 41.3

          ];

          • Re: Similar tables disturb charts
            Michael Blackmon

            Rename the Total Population field to something unique, unless you mean to have them associated.

             

            Rename the "Mobile User (Unique User)" to something unique also.