Hi,
I'd like to be able to create a map visual that will show where there are particular feedback issues aligned to a given department in different locations. Example data would be:
| Location | Comment Type | Business Area |
|---|
| London | Positive | HR |
| London | Negative | Operations |
| London | Positive | HR |
| London | Negative | Finance |
| Birmingham | Positive | Finance |
| Birmingham | Negative | Operations |
| Birmingham | Negative | Operations |
| Birmingham | Negative | HR |
| Birmingham | Negative | Operations |
| Cardiff | Negative | Operations |
| Cardiff | Negative | Finance |
| Cardiff | Negative | Finance |
| Cardiff | Positive | Operations |
| Cardiff | Negative | HR |
I can add a filter pane to switch between negative and positive comments based on the "Comment Type" dimension but I can't work out how I can use the "Business Area" and "Location" dimensions to give me an easy graphic showing spikes of issues. An example would be the above data showing me that Operations is a concern in Birmingham and Finance is in Cardiff. (Real data has much wider spread and more lines so issues are more obvious that 1 or 2 mentions!)
Very new to Qlik and syntax in general so any help in very simple language is appreciated!
