Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jleefjcapital
Contributor

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

Re: Removing null values in the point map

can u please share the expression that has been used ?

jleefjcapital
Contributor

Re: Removing null values in the point map

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
Contributor

Re: Removing null values in the point map

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

Not applicable

Re: Removing null values in the point map

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))