Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can we add manual field headers to pivot table like attached image format .
Hi,
Yes possible look at valuelist() function.
have a look at attached sample.
Regards
ASHFAQ
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.