adding manual field header to pivot table

Thu, 06 Nov 2014 07:34:18 GMT

Hi All,

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

Re: adding manual field header to pivot table

ashfaq_haseeb — Thu, 06 Nov 2014 07:40:21 GMT

Hi,

Yes possible look at valuelist() function.

have a look at attached sample.

Regards

ASHFAQ

Re: adding manual field header to pivot table

kuba_michalik — Thu, 06 Nov 2014 08:51:54 GMT

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.

topic Re: adding manual field header to pivot table in QlikView

adding manual field header to pivot table

Re: adding manual field header to pivot table

Re: adding manual field header to pivot table