Set analysis

[#1]

Hello,

I have a little problem with SET ANALYSIS.

I want to exclude more selections in my expression. If I exclude only one selection it's ok, but when I want exclude more the expression is wrong.

I try it with:

=

sum({$<Bewegungsdatum = {$(=varTagesDatum)}, keyProduktionslinie = {$(=varProdlinie)}, Quarter =, Month=, Week= >} Sales)

(but this is wrong)

Can everybody help me

Thank you

Klaus

[IAMDV]

Klaus - Please can you post with QV document (sample data) and please mention what you wanted to exclude... this will be easy to provide an answer.

Cheers - DV

[#3]

Hi Klaus,

It would be best if you told us what exactly you want to exclude.

You can use set operation ( - ) to exclude set of values from result. That means you can use the following in your set analysis;

Quarter =- {Month}

you could also try incorporating NOT MATCH in your set analysis

Hope this helps

[#4]

Hello all!

I send you a little application.

On the left side there are 4 selectionboxes. the selectionbox "Quarter", "Month" and 'Week" to not be a influence an the straight table.

I hope you understand, what I mean.

Thanks for help

Klaus

[IAMDV]

Dear Klaus,

Sorry I could not understand the requirement. Please can you explain it with more detail?

Thanks - DV

[#6]

Hi,

Try

=

sum({1<Quarter = >} Sales) instead

=

sum({$<Quarter = >} Sales)

Thanks,

Boopathi

[#7]

Hallo Klaus,

I answered your similar post in the german user group a bit late. But take a look at it. it seems to be a bug when using more then two expression like this "Quarter =," in one expression.

Regards, Roland

If someone (else) is interrested in an english answer, let me know

[#8]

Hallo Klaus again,

sorry, but didn't see your exam app not at once. Take a look at my modification in your straight table.

Regards, Roland