Hi,

I'm trying to build a map to display the location of our customers. Initially, I was trying to use the density layer, but the result kinda sucks and when zoomed out it displays a big symmetric colorful circle (idk if I did something wrong, but I was hoping it'd properly fill the map, instead of overflowing to the sea).

Then I tried to use the point layer, which did the job and I found to be better to our purposes, but is limited to 50k point. At this point we have 500k+ customers, and even tho I could filter the data (I have 2 area layers that I uploaded as GeoJSON and works), it'd be cool to view the frequency in the whole country when nothing is selected).

Having so many data points makes my map laggy so it does make sense limiting to 50k. I saw some stuff about clustering the data with GeoOperations. Tried that aswell, without success because it's limited to a 100k rows table (my geo table has 1.5kk rows and carries most of the zip codes, streets, etc.)

I'm just not sure how to proceed. If anyone could give me a direction I'd be thankful.

So far, the map looks like this when unfiltered and zoomed out (displaying every store and max customers possible):

When zoomed in and with a state selected it will show the second area layer (the state "intradivision"):

This is the best I could do, but it's very laggy and therefore useless.

How can I achieve something similar and have a better performance? Should I cluster the customers by proximity? How? Should I use density layer instead? Why?

Any help is appreciated.

hi all,

I am trying to set up an external task to run .bat file from the qmc but not working for me nor I can see why.

I am able to run the task by double clicking to it using the Qlik service account with no issues. Any idea what do I need t do differently?

Team,

I am new to Qlik and I am struggling on functions e.g. aggr() and count() not sure how to achieve the following?

Data:

1, PERSON1, 4/1/2024

2, PERSON1, 4/3/2024

3, PERSON1, 4/10/2024

4, PERSON2, 4/1/2024

5, PERSON2, 4/2/2024

6, PERSON1, 4/11/2024

Below is the desired output:

Person1: 5 Occurrences in April

Person2: 2 Occurrences in April

Similarly for the other months......

Any help would be appreciated! Thanks in advance 🙂

Kindly advise which kind of charts should I use for getting these box containers in Qlik sense.  Need this kind of box chart which contains Circle with color and scale with Avg and reporting month

Hi all,

I have a qlikview application with Geo Analytics map. I need to import it in Nprinting report, but when I place the map object as an Image in Qlik Nprinting ppt, it shows blank. Is there any other way of importing Geo Maps to Qlik NPrinting?

Hello,

At the moment I have two triggers, one for the connection: so that the metadata connection reload takes place early in the morning and another trigger on the publish task so that the report is published in the afternoon.

but what I'm looking for is if there are any possibilities to configure a trigger condition in Nprinting to ensure that the publish task is only executed when this metadata connection is successfully reloaded,

Thank you very much for your help

A few days ago our Qlik Server host crashed and when trying to restart services there is an error regarding the Qlik Sense Service Dispatcher. The error states "The description for Event ID 300 from source Qlik Sense Service Dispatcher cannot be found. Either the component that raises the event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer."

Does anyone know how to resolve this issue?