How to format the tooltip on a vizlib pivot table?

jaipersr — Sat, 16 Nov 2024 02:40:36 GMT

Hi Everyone,

I am trying to add a tooltip onto a measure that is within a vizlib pivot table. I would like the tool tip to contain two measures. Lets say measures X and Y. I don't have an issue displaying the two number because I just use '=X&Y' to concatenate the output. I would like to put them on different lines which I am having trouble doing. I would like my out put to look like the following:

I have already tried to put '=X&CHR(10)&Y' and '=X&CHR(13)&Y'. The CHR() function seems to only add a space character. Any thoughts on how to add a new line character?

Re: How to format the tooltip on a vizlib pivot table?

Arcticat500 — Thu, 27 Jun 2024 17:01:38 GMT

I know this is an old question, however, I also struggled with this in a concat( expression for the tool tip and never found documentation on it. Today I accidentally discovered a solution, however!

To give the two row result, '=X&'<br>'&Y'

For a Concatenation delimiter (so multiple results appear on their own line), use Chr(10)&'<br>' as your delimiter, and now your results get a carriage return at end of each value.

topic Re: How to format the tooltip on a vizlib pivot table? in App Development

How to format the tooltip on a vizlib pivot table?

Re: How to format the tooltip on a vizlib pivot table?