topic Re: Visualise issues by location in QlikView

Visualise issues by location

Anonymous — Mon, 09 Jul 2018 14:02:33 GMT

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!

Re: Visualise issues by location

vishsaggi — Mon, 09 Jul 2018 15:42:16 GMT

Does this help?

Re: Visualise issues by location

Anonymous — Mon, 09 Jul 2018 15:44:43 GMT

Great way of looking at it! I'd perhaps become too fixated on using a map.

Could you share how you produced that?

Re: Visualise issues by location

vishsaggi — Mon, 09 Jul 2018 16:13:23 GMT

Right click - new Sheet Object - Chart

and Add a grid chart and use as below:

Re: Visualise issues by location

Anonymous — Mon, 09 Jul 2018 16:34:10 GMT

Ah, ok. I'm using Qlik Sense Desktop April 2018. Doesn't appear to have grid chart as an option.

Re: Visualise issues by location

vishsaggi — Mon, 09 Jul 2018 16:38:45 GMT

Oh ok. Probably not sure may be you need to use an extension for Qliksense Grid chart. Look in Qlikbranch for any extensions.