I have a frequently reloaded dataset of US Postal Codes that are associated with current weather alerts. typically, there are 5000+ records in the dataset, and it means that rendering each respective area brings down app performance. Any recommendations on how to aggregate the county areas created by the postal codes for each weather alert and create one large alert area? Screenshot of the current map below. Thanks!
And of course this will requires a Qlik GeoAnalytics license which I assume you´ve got.
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
You were right about the Table field entry and after some other changes I came past the operation form. I noticed that in the example in the table field in the SQL statement it shows “tableFields='State,State,SalesArea'“ while I just get “tableFields='postcode4,pc_areaId'”. I tried with a 2nd potcode4 field but that failed. Can you explain why this is?
Also I’m using postal codes which (in my case) get plotted on the map by polygons but I do not get the code to load with that (see error image below) so I changed that to “geometryType='LOCATIONNAMEDAREA'”. Do you know why that is?
After all that the code does load but when I set up the map in the app I get a very different result. Sometimes even four overlaying area’s while the date was loaded in with the “loadDistinct='YES'”.
So I ran a little test to see what happens in the example if there are two states with the same name assigned to different sales areas but it got just inserted in the last sales area. Therefore I think there is still something is going wrong in my app.
Sorry for the long post but I find this to be a difficult part of QS and till now I could not find a good guide that explains why things go right or wrong.