Link Custom Tooltips to Qvd file

[Sarah_N]

Hello!

I would like to make unique tooltips to show events that create significant changes to a line graph, or to note events that happened on specific dates. Rather than making 1.000 footnotes, is there a way to write an expression or create a variable that would tie a tooltip to info in an Excel sheet behind a QVD? Or any other alternative to tooltips I should consider? 

Thank you for your wisdom and help!

[ajaykakkar93 · Accepted solution]

Hi,

I have done this activity please follow the below steps

• Create an Excel
• Create 2 sheet 
• TooltioDetails with these columns
  • unique ID
  • TooltipData
• ApplicationDetails with these columns
  • unique ID
  • application
  • sheetname
  • objectDesc
• I loaded the Excel in qlik with the filter of application by loading ApplicationDetails
• Did a Left Join(ApplicationDetails) to the above table by loading TooltioDetails
• Then created a new variable using the parameter
• If don't know about parameterized variables look into this link: creating-parameterized-variable-in-qlik-sense-and-qlikview
• Use ONLY() with set analysis having to filter [unique ID]
• Then pass the unique ID to the variable
• you are done 

The same can be used to create a multi-language qlik sense application.

[Sarah_N]

Thank you so much! Also, I didn't have parameterized variables, but I do have another dashboard where I would love to use that, so that link will be very useful as well. Genius! 

[ajaykakkar93]

Hi @Sarah_N ,

Hope this solution helps you learn & share this with others.