topic Merge heading in pivot table in QlikView

Merge heading in pivot table

Anonymous — Sat, 05 Sep 2015 22:48:32 GMT

Actually I used text object with the following expressions = Max(Year) &' / ' & Max(Year-1) and =Max(Year) &' / BUDGET'

I am trying to add heading in pivot table .

I read the following post but I didn't undestand how to use it in my case ?

sinanozdemir — Sun, 06 Sep 2015 18:35:59 GMT

Hi,

Maybe something like this:

I used ValueList() in one of the dimensions:

And in the expression, I used Pick(), Match() and ValueList() all together:

I am also attaching the qvw in case you need that as well.

Hope this helps.