Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
harald_popp
Partner - Contributor
Partner - Contributor

Pivottable - Header

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

8 Replies
sushil353
Master II
Master II

Hi,

Try below in your header lable:

Assuming Value is your horizontal dimension name in pivot table.

=Value&'|'&Year

HTH

Sushil

sorrakis01
Specialist
Specialist

Hi,

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

Regards

harald_popp
Partner - Contributor
Partner - Contributor
Author

hi Sushil,

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

thx for your help.

-Harald

pivot_table_year.PNG.png

sorrakis01
Specialist
Specialist

Hi,

I don't understand where is the problem.

Can you upload the exercise?

harald_popp
Partner - Contributor
Partner - Contributor
Author

i have added a demo!

thx for your help.

regards

sorrakis01
Specialist
Specialist

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

harald_popp
Partner - Contributor
Partner - Contributor
Author

thanks for trying!

Not applicable

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