Cant find the right table,do you have any suggestions?

[LaurensH]

Hi Qlik community,

I recently started using Qlik and find it really useful but I have one problem. I need to create a graph for my work as is depicted in the picture that I attached to this question.

The problem is that I need to make some sort of Matrix where I can show multiple companies on 2 axes (qualitative data). 
I do not know how such a graph would be called, but I looked around in Qlik and I cannot find anything that comes even close to what I need. 

The companies that are in the graph (lets just call them the bubbles in the chart for now) do not need to correspond to a certain size. It would be nice if they would show as bubbles, but it is also fine if you just see the count in the quadrant. I would need the possibility to select a quadrant(s) and then get a list of all the companies in that quadrant. 

Would really appreciate some advice on how to create such a graph or a possible workaround.

Thank you in advance!

- Laurens

[docpuddu]

Hi,

scatter chart would fit your request

https://www.youtube.com/watch?v=GHxGnxNt7Bk

HTH.

Ciao,
/A

[dplr-rn]

not exactly what you are looking for but you can create some thing similar using pivot tables

X and Y as dimensions (move Y as column) and measure as Concat(Company,','). Output like below

[LaurensH]

Hi A,

This does not work for me since I can only make a scatterplot with quantitative data. I want to use qualitative data for the x/y-axis, or am I doing something wrong?

Thanks

[LaurensH]

Hmm, not exactly what I was looking for but would be a good workaround. Thanks!

[docpuddu]

I understand...

However as far as I can see C1 (A,a) and C2 (A,a) have actually different position in the graph.

In other words this meas they have different coordinates (but similar... so they fall in the same quadrant)

Assuming that I proposed a "scatter" approach, is that adaptable?

Ciao,
/Andrea

[LaurensH]

Sorry for the confusion with the drawing I made. They do not have different coordinates, they have exactly the same coordinates but I would want them to still be separated from each other. I found a workaround by using a heatmap. Does not show me the bubbles but I get a accumulation. 

Thanks for the help