Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Partner
Partner

Visualise issues by location

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:

   

LocationComment TypeBusiness Area
LondonPositiveHR
LondonNegativeOperations
LondonPositiveHR
LondonNegativeFinance
BirminghamPositiveFinance
BirminghamNegativeOperations
BirminghamNegativeOperations
BirminghamNegativeHR
BirminghamNegativeOperations
CardiffNegativeOperations
CardiffNegativeFinance
CardiffNegativeFinance
CardiffPositiveOperations
CardiffNegativeHR

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!

5 Replies
vishsaggi
Esteemed Contributor III

Re: Visualise issues by location

Does this help?

Capture.PNG

Partner
Partner

Re: Visualise issues by location

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

Could you share how you produced that?

vishsaggi
Esteemed Contributor III

Re: Visualise issues by location

Right click - new Sheet Object - Chart

and Add a grid chart and use as below:

Capture3.PNG

Capture.PNG

Capture1.PNG

Capture2.PNG

Partner
Partner

Re: Visualise issues by location

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

vishsaggi
Esteemed Contributor III

Re: Visualise issues by location

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