Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Line Graphs, and Expression visibilty in "pop-up" and Excel

Hi,

I have a line graph that shows 3 expressions (A, B and C) as lines in the graph.

When I put the mouse/cursor over a point in any of the lines - the value of the expression pops up (im not sure if pop-up is the right word, but still)...

2 questions:

1) Mouse-over with expression values showing in pop-up

=> is it possible to set it like if I drag the mouse over the lines, only the values for A and B shows in the pop-up, and that the value for C never shows when you drag your mouse over a line-point in the graph?

2) Export to Excel

=> How do I set that when you export this graph with three expressions/lines to excel, only A and B are exported/shown in/to the Excel Sheet?

Hope anyone can help. Thanx

1 Reply
m_woolf
Master II
Master II

Make a seaparate chart for C.

Overlay the chart for A&B and make everything transparent.

This will look like one chart, but when you hover over the chart only A & B will popup text.

When you export to Excel, only A&B will export.