topic Re: Qlik Sense Field name is merged and centered in App Development

Qlik Sense Field name is merged and centered

Gin009 — Mon, 10 Oct 2022 07:43:49 GMT

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

How should it be implemented?

Re: Qlik Sense Field name is merged and centered

Mark_Little — Mon, 10 Oct 2022 08:15:55 GMT

Hi @Gin009

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

Re: Qlik Sense Field name is merged and centered

Gin009 — Mon, 10 Oct 2022 08:30:48 GMT

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.

Re: Qlik Sense Field name is merged and centered

vinieme12 — Mon, 10 Oct 2022 08:51:41 GMT

how is your data structured?

can you post a sample?

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

Re: Qlik Sense Field name is merged and centered

Gin009 — Mon, 10 Oct 2022 10:03:36 GMT

Hi Vinieme12

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

Thank you!

Re: Qlik Sense Field name is merged and centered

vinieme12 — Tue, 11 Oct 2022 03:20:38 GMT

refer below

Re: Qlik Sense Field name is merged and centered

Gin009 — Tue, 11 Oct 2022 06:31:33 GMT

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!

Re: Qlik Sense Field name is merged and centered

vinieme12 — Tue, 11 Oct 2022 07:52:45 GMT

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

Re: Qlik Sense Field name is merged and centered

Gin009 — Wed, 12 Oct 2022 03:42:51 GMT

Thanks,vinieme12

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