topic Set analysis in QlikView

Set analysis

Tue, 05 Apr 2011 11:32:24 GMT

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

Set analysis

IAMDV — Tue, 05 Apr 2011 11:55:53 GMT

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

Set analysis

Tue, 05 Apr 2011 12:34:38 GMT

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

Set analysis

Tue, 05 Apr 2011 15:27:21 GMT

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

Set analysis

IAMDV — Tue, 05 Apr 2011 15:37:43 GMT

Dear Klaus,

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

Thanks - DV

Set analysis

Mon, 11 Apr 2011 19:57:10 GMT

Hi,

Try

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

sum({$<Quarter = >} Sales)

Thanks,

Boopathi

AW:Set analysis

Mon, 11 Apr 2011 20:06:22 GMT

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

AW:Re: Set analysis

Mon, 11 Apr 2011 20:19:27 GMT

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