topic Re: Pivottable - Header in QlikView

Pivottable - Header

harald_popp — Mon, 01 Dec 2014 10:36:53 GMT

hi,

i am using a pivot table and have a problem with the table header!

please see attached pics! is there an option for solving my problem?

thanks for you help.

regards

-Harald

Re: Pivottable - Header

sushil353 — Mon, 01 Dec 2014 10:41:28 GMT

Hi,

Try below in your header lable:

Assuming Value is your horizontal dimension name in pivot table.

=Value&'|'&Year

HTH

Sushil

Re: Pivottable - Header

sorrakis01 — Mon, 01 Dec 2014 10:50:16 GMT

Hi,

Use this in Caption = Value & ' | ' & Year (or '2013','2014').....

Regards

Re: Pivottable - Header

harald_popp — Mon, 01 Dec 2014 10:53:34 GMT

hi Sushil,

i tried your solution but i always get both years in the header!

thx for your help.

-Harald

Re: Pivottable - Header

sorrakis01 — Mon, 01 Dec 2014 10:55:14 GMT

Hi,

I don't understand where is the problem.

Can you upload the exercise?

Re: Pivottable - Header

harald_popp — Mon, 01 Dec 2014 11:11:29 GMT

i have added a demo!

thx for your help.

regards

Re: Pivottable - Header

sorrakis01 — Mon, 01 Dec 2014 11:41:50 GMT

Hi,

Sorry you're right, it doesn't work when you selected two or more year's values.

I don't find the solution, doesn't work fieldselection, substrtingcount....

Sorry I can't help you

Re: Pivottable - Header

harald_popp — Mon, 01 Dec 2014 12:03:43 GMT

thanks for trying!

Re: Pivottable - Header

Mon, 01 Dec 2014 12:42:16 GMT

I don't think it is possible here, You need to create flags in script. So, that you can use them in the expression labels