Set analysis-Include excluded values

[#1]

Hi,

I want to write a sum() expresion that include excluded values. How can i do it?

when i write sum({1<>}), it returns sum of all of possible values. I want to include grayed values.

[jonathandienst]

Hi

I think the answer to your question depends on the structure of your data model. It will be easier to suggest a fix and less testing for you if you could upload your model (or a sample if it large).

To upload, click the Use advanced editor link at the top right of the Reply form.

HTH

Jonathan

[#3 · Accepted solution]

Hi

as Jonathan said it depends on model and field you are using for selection

So if you have a Calendar table  you may use it to select 2013

you will have then Sales for 2013 (january only) and all forecasted monthes

best regards

Chris

[#4]

Thanks christian, it's working

[sunilkumarqv]

Hi,

           see the following set analysis for included Year={$(=Max(Year))} and excluded  Field -= {'value'}

=((Sum({<Year={$(=Max(Year))},Field -= {'value'}>}Amount))

Regards

Sunil

[bvssudhakar]

Hi Nicole Smith,

I have one requirement, here i attached one qvw file in that file

If i select for filter 1: Baby Clothes in Category Name, Aino Shoes from Product name, 2012 from Year and

for filter2:Baby Clothes in Category Name, Deuce Shirt from Product name, 2013 from Year

then i want out like this

2422	2/16/2012	Baby Clothes	Aino Shoes	Halle Köln	Bob Park	41
2422	2/16/2012	Baby Clothes	Deuce Shirt	Halle Köln	Bob Park	11
4665	1/21/2013	Baby Clothes	Aino Shoes	La Moda d'il Futuri	Ricardo Gucci	61
4665	1/21/2013	Baby Clothes	Deuce Shirt	La Moda d'il Futuri	Ricardo Gucci	12

But output is not showing like this, it is showing selections related 572 rows some thing

Give some suggestions to out from this situation

Thank you in advance

Sudhakar