Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
md22
Contributor
Contributor

Missing data on chart layer

Income Banding.png

I am trying to plot income distribution island-wide by planning area. I have about 500 data points which should appear on the chart layer plotted on the map, however, many data points are missing. The geodata file containing latitude and longitude of the planning areas are fine as I am able to plot all planning areas as an area layer. As seen in the screenshot attached above, many planning areas do not have income distribution pie charts shown in their locations. The raw data imported does have data points for all planning areas.

Additionally, it would be good if I can present a legend after grouping the income bandings and colour-coding them. I understand that colour by expression will allow me to do the colour-coding but I can't seem to find a way to include a legend that is custom made.

Kindly help with how I can solve this issue. 

Labels (4)
1 Reply
Patric_Nordstrom
Employee
Employee

If many points are missing data for the charts, I recommend having two layers, one point plus a chart layer.

For complex coloring I recommend to create a dimension that holds the classification and use a bar chart or similar to serve as a legend.

For inspiration see classcoloring.qvf https://community.qlik.com/t5/Qlik-Sense-Documents/Top-10-QGA-tricks-Qonnections-2019/ta-p/1581145

 

Thanks,

Patric