Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
msapre
Contributor II
Contributor II

How to Separate Overlapping Points in Qlik Map

I've made a map that displays the total par held for each company at different zip codes.

It currently looks like this (the red cross out is just the name of the company). The zip code is 02210. So there's 4 companies in 02210, but the tooltip only displays one company.

msapre_3-1747230067693.png

I want to achieve a few things in this visualization:

1. Offset the points at each zip code so I can hover over each individual point (I don't want to change the size of the points). This is difficult because I don't have the geoanalytics converter license. Since all of these points are mapped by zip, how would I do this?

2. Get rid of any points where par = 0. 

3. If there are any companies that completely overlap anyway, is there a way to have the tooltip display all the points?

Below is my current expression editor for the points.

{<COUNTRYCODE={'USA'}, REPDTE = {"$(=Date([DateFilter], 'MM/DD/YYYY'))"}, PARHELD = {'>0'}>}Dual(COMPANYNAME & ' (' & ZIP & ')', ZIP) 

How do I change it to achieve all three of these solutions? Right now points are displaying even if Sum(par) = 0.

0 Replies