Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
=sum( {$<Product = E({$} Product)>} Sales )
E() representing the set of the excluded values of a field
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.
Hi,
Try this
Sum({<Year={"2014"},Product-={"Product A"}>}Sales)
Regards
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
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.
Max and Ashfaq, In reply to Jonathan I try to better explain the case.
Regards.
=sum( {$<Product = E({$} Product)>} Sales )
E() representing the set of the excluded values of a field
See this example
Hi,
Hope the attached appln helps!
Kiru
HI.
Thank you all for the help.
Regards.