Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

No visualizar puntos nulos o cero en mapa / Don't display null or cero points on the map

Hi, 

I have the following table (Sales is a measure):

CitySales
Rancagua$345.000
Santiago$2.856.000
Melipilla 
Viña del Mar$580.000
Macul$390.000

 

In the table, melipilla sales is null and is plot like a "x" in map:

Sin título.png

I need to remove null or zero values from the display.

Thank.

1 Reply
Highlighted
Digital Support
Digital Support

The only way of which I know would be the display settings of the underlying chart properties, turn off the display nulls/zero values there.  The only other option would be to check for zero in the load script and skip any places that have 0 etc. that way.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.