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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Tables/selection issue

I am looking to create a table that displays the top 10 sales by sales person that will not change as the user selects other criteria. The information must only change as the document is loaded.

Is there a way to switch off selection for just this object ? Any help is greatly appreciated.

Paul

3 Replies
justinasp
Creator
Creator

Hey, Paul,

read about Set Analysis in QV help. You can write an expression in a chart object ignoring selections.

Take care,

Justinas

Not applicable
Author

Hi,

use a straight table with an expression like

Sum({1} sales)

In chart properties, tab presentation, set Max Number equal to 10.

Alex

Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Let me remind to everybody - there WAS life before Set Analysis!

Right-click on the chart and select "Detach". The chart will never react to any selections, until you decide to "Attach" it again.

With all the beauty of Set Analysis, let's not forget about the basics!