Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

adding manual field header to pivot table

Hi All,

Can we add manual field headers to pivot table like attached image format .

2 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

Yes possible look at valuelist() function.

have a look at attached sample.

Regards

ASHFAQ

kuba_michalik
Partner - Specialist
Partner - Specialist

No, what you have in your example is definitely not possible. You have merged headers across levels and no QlikView table can do that, for starters.

The method given by Ashfaq Mohammed can be useful when you want to show every single expression in every single group, but only then. It's possible to kinda get around this by making a single big expression that calculates differently depending on where in the chart it is, but that's complicated and a performance killer, and still won't give you the exact result you want.

Another method is to stick a couple of extra one-row table charts on top and align them to look like headers. It's good if looks in QlikView are the only consideration, but of course you can't export something like that to Excel, or use caption buttons.