Hover text on headers

rtr13 — Sat, 16 Nov 2024 01:58:56 GMT

Does anyone know how to add hover text onto headers within a pivot table? I have tried to input an if statement as followed:

=if(Header='Previous Year','Previous Year' &chr(13)&chr(13)&chr(13)&'The previous rolling 12 months: '&pstartdate&'to'&penddate,
if(Header='Current Year','Current Year' &chr(13)&chr(13)&chr(13)&'The current rolling 12 months: '&cstartdate&'to'&cenddate))

But, with I do this i get the ... after the header which I am looking to avoid. Is there a way to add hover text without getting the ... after the header? I appreciate the help.

Thanks!

Re: Hover text on headers

sergio0592 — Mon, 11 Nov 2019 21:05:47 GMT

Hi,

Try to overlap the header pivot table with a text object.

topic Re: Hover text on headers in QlikView

Hover text on headers

Re: Hover text on headers