Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jim_chan
Specialist
Specialist

how to create header group in pivot table?

hi guys,

i have a pivot table below, as a sample, i want to add in header 1 - just for 1 expression sum(Sales), header 2 count(F1).

i have also attached a sample qvw file with inline data as well. Please help guys!

screenshot3.jpg

Thanks

Rgds,

Jim

1 Solution

Accepted Solutions
jim_chan
Specialist
Specialist
Author

Hello Federico,

I have finally solved it by myself, and would like to share with you and all, if so happen , creating header and child are part of your pivot table requirement.

The Solution is as per my attached here Header & Child.qvw file.

Rgds,

Jim

View solution in original post

4 Replies
fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

Try with atteched file.

Saludos.

jim_chan
Specialist
Specialist
Author

Hi,

Thanks for your sample file. I have a look on it. but not quite lookalike with my expected result. The expected result, should have header, as well as the expression. like this:

screenshot3.jpg

Rgds,

Jim

jim_chan
Specialist
Specialist
Author

Hello ..anyone out there can helppppp???? pleaasseeee.

jim_chan
Specialist
Specialist
Author

Hello Federico,

I have finally solved it by myself, and would like to share with you and all, if so happen , creating header and child are part of your pivot table requirement.

The Solution is as per my attached here Header & Child.qvw file.

Rgds,

Jim