Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
spividori
Specialist
Specialist

Excluded values

Hi.

How should I do to see the excluded values ​​of the current selections. Current selections include: Year, month, day, product, etc. For example, selecting 2014, Product A, I need to see the sales of all products of the year 2014, but not the product A.

Regards.

1 Solution

Accepted Solutions
maxgro
MVP
MVP

=sum( {$<Product = E({$} Product)>} Sales )

E() representing the set of the excluded values of a field

View solution in original post

9 Replies
JonnyPoole
Employee
Employee

Is this for a chart ?  ... So if a user has a chart that shows sales for regions by year, and a user selects North America and 2014 you want the chart to show   everything except for North America and 2014 ?  Or is it for another use case ? Please elaborate on the exact need.

PrashantSangle

Hi,

Try this

Sum({<Year={"2014"},Product-={"Product A"}>}Sales)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
ashfaq_haseeb
Champion III
Champion III

Hi,

Go through the set analysis wizard

http://community.qlik.com/docs/DOC-4708

you can try this too

Sum({<Year={2014},Product-={'A'}>}Sales)


Regards

ASHFAQ

spividori
Specialist
Specialist
Author

Yes, it's for a chart.

In a chart I show sales by product and have a list where I can select year, month and day. When I select a year, eg. 2014 and a month, eg. Aug, shows me the sales of all products. I select one of these products. I need another graph showing the sales of excluded products.

In my example I use: sum( {1-$} CANTIDAD ), exclude the product, but does not take the selection I make in Year and month.
I hope you understand, my English is poor.


Regards.

spividori
Specialist
Specialist
Author

Max and Ashfaq, In reply to Jonathan I try to better explain the case.


Regards.

maxgro
MVP
MVP

=sum( {$<Product = E({$} Product)>} Sales )

E() representing the set of the excluded values of a field

ecolomer
Master II
Master II

See this example

Not applicable

Hi,

Hope the attached appln helps!

Kiru

spividori
Specialist
Specialist
Author

HI.

Thank you all for the help.

Regards.