4 Replies Latest reply: Jun 13, 2015 4:17 AM by Ashish Tuti RSS

    Removing null values in the point map

    Jes Lee

      I am trying to remove the null values in the point map.   Currently, I'm getting this- where the null values are appearing as "Xs".  This is even after I deselect "Show Null Values".  Is there something I'm missing?

       

       

      Thank you,

       

        • Re: Removing null values in the point map
          Ashish Tuti

          can u please share the expression that has been used ?

            • Re: Removing null values in the point map
              Jes Lee

              I've created the GeoKey-

               

              GeoCode:

              LOAD

                  MSA,

                  "Geographic Area (sq. miles)",

                  GeoMakePoint(Latitude, Longitude) as GeoKey_MSA

              FROM [lib://GeoCodes/GEOCODES.xlsx]

              (ooxml, embedded labels, table is MSA);

               

               

               

              Then, I overlaid it with data constructed in this manner-

               

               

              HOI:

              LOAD

                  Date(Date#("Date",'YYYYMMDD'),'M/D/YYYY') AS DATE,

                   "NATIONAL" as [HOI_USA]

              FROM [lib://HOUSING/HOI_MSA.xls]

              (biff, embedded labels, table is [8$]);

               

              Concatenate(HOI)

              LOAD

                  Date(Date#("Date",'YYYYMMDD'),'M/D/YYYY') AS DATE,

                   "Abilene, TX" as [HOI_MSA],

                   'Abilene, TX' as [MSA],

                   'Texas' as [STATE]    

              FROM [lib://HOUSING/HOI_MSA.xls]

              (biff, embedded labels, table is [1$]);

               

              Concatenate(HOI)

              LOAD

                  Date(Date#("Date",'YYYYMMDD'),'M/D/YYYY') AS DATE,

                   "Akron, OH" as [HOI_MSA],

                   'Akron, OH' as [MSA],

                   'Ohio' as [STATE]

              FROM [lib://HOUSING/HOI_MSA.xls]

              (biff, embedded labels, table is [1$]);

               

              Concatenate(HOI)

              • Re: Removing null values in the point map
                Jes Lee

                Then I used the map application and used the MSA as the dimension and the HOI data as the measure.