Discussion board where members can get started with Qlik Sense.
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?
can u please share the expression that has been used ?
I've created the GeoKey-
"Geographic Area (sq. miles)",
GeoMakePoint(Latitude, Longitude) as GeoKey_MSA
(ooxml, embedded labels, table is MSA);
Then, I overlaid it with data constructed in this manner-
Date(Date#("Date",'YYYYMMDD'),'M/D/YYYY') AS DATE,
"NATIONAL" as [HOI_USA]
(biff, embedded labels, table is [8$]);
"Abilene, TX" as [HOI_MSA],
'Abilene, TX' as [MSA],
'Texas' as [STATE]
(biff, embedded labels, table is [1$]);
"Akron, OH" as [HOI_MSA],
'Akron, OH' as [MSA],
'Ohio' as [STATE]
Then I used the map application and used the MSA as the dimension and the HOI data as the measure.
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,