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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.