Qlik Sense Field name is merged and centered

[Gin009]

In Qlik Sense,it is possible to merge  and center field names like Excel.

How should it be implemented?

[Mark_Little]

Hi @Gin009 

You can create a Pivot table, but you can't do exactly that with the standard functionality. 

[Gin009]

Hi mark6505，

I have tried to use Pivot table,but I can't seem to achieve the effect I want.It is estimated that I need to use a plug-in to achieve it.

[vinieme12]

how is your data structured?

can you post a sample?

just used= Valuelist('SCORE') as  column Dimension

[Gin009]

Hi  Vinieme12 

The ultimate goal is to realize the report you provided,the data structure is as follows.

Thank you!

[vinieme12]

refer below

[Gin009]

Hi vinieme12

I tried to use pivot table and it showed this effect.

Currently I can only implement one merged dimension,but what if I have multiple merged dimensions.

This is what I want to show in the end.

Thank you!

[vinieme12]

Transform your data as below, transpose columns to rows

CrossTable(Subject,Score,3)
temp:
Load * inline [
stu_name,stu_id,stu_sex,chinese,math,english,physics
Jack,233,f,90,30,54,45
Jerry,234,f,90,23,23,78
Tom,243,m78,68,78,47
];

dummyDim:
load *,recno() as sub_SortId inline [
dim,dimNum,Subject
Required,1,chinese
Required,1,math
Elective,2,english
Elective,2,physics
];

exit script;

Chart

[Gin009]

Thanks,vinieme12

I'll give it a try,I'll ask you if I don't understand 😁