Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In Qlik Sense,it is possible to merge and center field names like Excel.
How should it be implemented?
Hi @Gin009
You can create a Pivot table, but you can't do exactly that with the standard functionality.
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.
how is your data structured?
can you post a sample?
just used= Valuelist('SCORE') as column Dimension
Hi Vinieme12
The ultimate goal is to realize the report you provided,the data structure is as follows.
Thank you!
refer below
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!
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
Thanks,vinieme12
I'll give it a try,I'll ask you if I don't understand 😁