Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
aslamshaikh
Contributor II
Contributor II

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

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.

Table.png

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

];

aslamshaikh_0-1642780496328.png 

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

 

Thanks and Regards

Aslam Shaikh

2 Replies
Chris_Rice
Support
Support

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
Contributor III
Contributor III

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

nevopotokcloudinary_0-1643705999933.png

 

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;