Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jleefjcapital
Creator II
Creator II

Removing null values in the point map

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,

4 Replies
Not applicable

can u please share the expression that has been used ?

jleefjcapital
Creator II
Creator II
Author

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)

jleefjcapital
Creator II
Creator II
Author

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

Not applicable

Are value of expression at Xs coming to null or negative ?. May be expression can be used somewhat like this :

if(sum(HOI) = null() or sum(HOI) < 0,

     0,

     sum(HOI))