Radar chart qlik sense

[darpao]

Hi,

I can not able to create a radar chart with my data.

Below you can see what I want to do in Qlik Sense and that I can easily do with Excel.

I want to select a company and plot its scores together with the average of the companies that belong to the same type of selected company. In this case if I select Company 9, I want to calculate on the fly the average of Type C and plot it as benchmark.

Companies	Type	Score 1	Score 2	Score 3
Company 1	A	4	1	7
Company 2	A	8	2	4
Company 3	B	6	10	5
Company 4	A	1	7	5
Company 5	C	7	3	8
Company 6	B	4	2	4
Company 7	A	2	10	7
Company 8	C	2	3	1
Company 9	C	8	1	3
Company 10	B	3	2	1
Average	A	3,8	5,0	5,8
	B	4,3	4,7	3,3
	C	5,7	2,3	4,0

I was not able to find an example on this community also if I think this should be a typical situation.

Thanks

[Lisa_P]

Hi,

I could not see how to do it in one chart, but can make it happen in two. The radar chart extension takes 2 dimensions and one measure.

I did have to unpivot the Scores and create a dimension for Score 1/2/3(ScoreNumber).

So the first chart has Type and ScoreNumber as dimensions and Avg({<Companies=>}ScoreValue) - ignoring Companies selection.

The second chart has Companies and ScoreNumber as dimensions and Avg({<Type=>}ScoreValue) - ignoring Type selection.

[Zhandos_Shotan]

Hi

It possible but need manually select Average in Companies and Type dimension. 

1. Add Average row in companies dim

2. Make Crosstable load to Scores dim

SCRIPT:

[Tab]:
LOAD * INLINE
[
Companies,Type,Score 1,Score 2,Score 3
Company 1,A,4,1,7
Company 2,A,8,2,4
Company 3,B,6,10,5
Company 4,A,1,7,5
Company 5,C,7,3,8
Company 6,B,4,2,4
Company 7,A,2,10,7
Company 8,C,2,3,1
Company 9,C,8,1,3
Company 10,B,3,2,1
Average, A
Average, B
Average, C
](delimiter is ',');

CrossTable (Scores, Score, 2) Load
*
Resident Tab;

drop Table Tab;

3. Use expression:

if(Companies='Average', avg({<Companies=>} total <Type, Scores> [Score]), Avg([Score]))

See pic and app in attachment:

Regards