Help for creating a spider chart

[LaurensH]

Hi QlikSense community,

I have a question, I am trying to make a spider chart as in the image (sorry for my Microsoft Paint skills).

I want to have 4 different criteria that I would score on. For each rank I want to have a potential score (red) and a score representing the current status (green). This way we can see how much growth can still be realised. How would I do this in QlikSense? I am struggling with how to get my data in such a way. Would be great if you could help with that.

Thanks!

[LaurensH]

To add to this, this is how I have my data right now. Thanks

[Clever_Anjos]

Did you try the Radar Chart? I think that's what you need

[LaurensH]

Hi, yes I tried that one as well but I cannot get it in the way that I want it to be.

[Clever_Anjos]

Try searching Branch for another extension, maybe you can find a more suitable to your needs

[Clever_Anjos]

From your screenshot: each company is supposed to be a line?

[Clever_Anjos · Accepted solution]

Besides color (Radar colors are kind of hardcoded) I could to this

[Sheet1]:
LOAD
[Startup name],
[Criteria 1],
[Criteria 1 potential],
[Criteria 2],
[Criteria 2 potential],
[Criteria 3],
[Criteria 3 potential],
[Criteria 4],
[Criteria 4 potential]
FROM [lib://AttachedFiles/Book1.xlsx]
(ooxml, embedded labels, table is Sheet1);

For i = 1 to 4
Table:
Load
[Startup name],
'Criteria $(i)' as Criteria,
'Potencial' as Dimension,
[Criteria $(i) potential] as [Value]
Resident [Sheet1];

Load
[Startup name],
'Criteria $(i)' as Criteria,
'Current' as Dimension,
[Criteria $(i)] as [Value]
Resident [Sheet1];
next

[LaurensH]

This is exactly what I would need. I am really sorry, but I would not know how to replicate that even though you gave me the code. How would I do this?

Thanks!

[Clever_Anjos]

It's about remodeling your data, because radar chart expects two dimensions and one measure.

You have 8 data columns (for each criteria you have the the value and the potential)

I've created another table where you can have "Criteria1", "Criteria 2"... as one dimension and another field with current/potential 

With this new table using the radar is straighforward