'No data to display' - QlikView Scatter Chart with Maps
Hello,
I was about to ask a question about a QlikView Scatter Chart, but I answered the question myself as I was writing it. I just wanted to share this just in case someone else may have missed this small detail as well.
" I have implemented a scatter chart with a map quest static image for a background. For the most part, the scatter chart and the map work great. However, if I happen to select a certain city or a few different addresses to display on the chart, the scatter chart shows 'No data to Display'. To debug:
- I have put the link to the static image background into a text box and followed the link whenever that happens. The map works just fine.
- I have also put all the data that is to be displayed in list boxes and found that no data is missing.
- I then tried each separate address that was supposed to be displayed in the chart when a city was selected. They worked fine separately, but did not display when they were all selected.
To be a little more clear what data that I explicitly used in the scatter chart:
Dimension: City
The Expressions that I use: latitude, longitude,Sum(Total_Ounces). (latitude and longitude are the long equations for the map to work)
The map and scatter chart works for the most part. It's only when I get specific about which data points I choose does it not display. "
My problem was I was, I did not have my dimension as a drill down group where it could display State, City, or Address. I'm guessing that when I selected a group of addresses, it must not have had the data to display because there were no dimensions. I do not quite understand what happened, but this was the fix that I had for it.
