Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to achieve this using set analysis?

Hi, in my application, there is a list box for user to choose which companies they would like to exclude from the chart. My chart is used to display the total revenue of each company for each fiscal year. How should i write the set analysis in order to achieve the purpose of excluding those companies selected by the user? Thanks much, I really need a solution asap. Thanks in advance!

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hei

attach is an example of what you asked for

the expression goes like this

assume the user select values in the company field

sum({<company=E(company)>} Sales)

hope its helps you

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hei

attach is an example of what you asked for

the expression goes like this

assume the user select values in the company field

sum({<company=E(company)>} Sales)

hope its helps you

Not applicable
Author

Hi Liron, thanks a lot for your help! I have another problem (Please refer to this post). Would you mind to help me? Thank you very much!