How to give Header for the measure in Pivot Table or in Normal Table

[aslamshaikh]

Hello Team,

I want to create a table like below which is having some dimension and some measure but that measure are having two different  headers, I am not getting how can i achieve this, can someone please guide me here.

I tried something like below, created one inline table and added the two columns in pivot table column

Header:
Load * Inline
[

Header 1 , Header 2

Header 1 , Sub Header 1

Header 1 , Sub Header 2

Header 1 , Sub Header 3

Header 12, Sub Header 1

.

.

Header 2 , Sub Header 5

];

 

But this is not working as shown in the image above, please help me to resolve this issue.

Thanks and Regards

Aslam Shaikh

[Chris_Rice]

Hey!

Take a look at this part of the Help site:
https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/Visualizations/Pivot...

If you scroll down to "Pivoting your data in the table", the second image shows what you're trying to accomplish. 

Thanks!

[nevopotokcloudinary]

I've created a second inline with sub-header title and presented it in the pivot

Load * Inline [
dim1, dim2,header,subheader, value
A,AB,header1,header1,1
A,AC,header2,header2,2
A,AD,header1,header3,4
B,BB,header1,header1,1
B,BC,header2,header2,2
B,BD,header1,header3,4
];

Load * Inline [
header,subheader,title
header1,header1,t1-1
header1,header3,t1-3
header2,header2,t2-2
];
exit Script;