topic Re: Excluded values in QlikView

Excluded values

spividori — Wed, 01 Oct 2014 15:02:21 GMT

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.

Re: Excluded values

JonnyPoole — Wed, 01 Oct 2014 15:04:54 GMT

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.

Re: Excluded values

PrashantSangle — Wed, 01 Oct 2014 15:06:04 GMT

Hi,

Try this

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

Regards

Re: Excluded values

ashfaq_haseeb — Wed, 01 Oct 2014 15:08:52 GMT

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

Re: Excluded values

spividori — Wed, 01 Oct 2014 21:20:05 GMT

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.

Re: Excluded values

spividori — Wed, 01 Oct 2014 21:23:37 GMT

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

Regards.

Re: Excluded values

maxgro — Wed, 01 Oct 2014 21:41:44 GMT

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

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

Re: Re: Excluded values

ecolomer — Wed, 01 Oct 2014 21:44:11 GMT

See this example

Re: Excluded values

Wed, 01 Oct 2014 22:21:21 GMT

Hi,

Hope the attached appln helps!

Kiru

Re: Excluded values

spividori — Thu, 02 Oct 2014 12:02:06 GMT

HI.

Thank you all for the help.

Regards.