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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set Analysis

Guys,

I need the data of an object (Table) to be unchanged when any of the filters or dimensions is selected. The data should be static. Plz help.

3 Replies
MK_QSL
MVP
MVP

SUM({1}Sales)

This will give you unchanged TotalSales irrespective of selection..

MK_QSL
MVP
MVP

abhinavbose

I can see that you are asking many questions (which is good) but not willing to close the thread.

This is not a good practice. Members will not take interest to answer your questions.

Also whatever threads you have closed, all are using Mark as assumed answered.

If you don't know how to close the thread, please check below link.

Qlik Community Tip: Marking Replies as Correct or Helpful

IMG_1408.JPG

Anonymous
Not applicable
Author

I find this link very usefull. It generates expression dynamically.

http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=

Hope this helps