topic Re: Set Analysis exclusion on all fields from a particular table in QlikView

Set Analysis exclusion on all fields from a particular table

Mon, 05 Sep 2011 07:55:40 GMT

Hi there,

Bit new to the Set Analysis. I would very much like to know if there is a simple way to exclude selections in an expression from an entire table? Is this possible?

Kind regards

Jonathan

Set Analysis exclusion on all fields from a particular table

Wed, 07 Sep 2011 08:24:20 GMT

HI Jonathan,

You can exclude something in Set analysis by using the - sign

for example:

SUM(

Dimension -= {'Value'}

Sales

)

Regards,

Reyman

Re: Set Analysis exclusion on all fields from a particular table

swarup_malli — Wed, 07 Sep 2011 14:09:21 GMT

Jonathan,

I'm attaching an example(.qvw).

Regards

Swarup

Set Analysis exclusion on all fields from a particular table

SunilChauhan — Wed, 07 Sep 2011 14:40:50 GMT

sum({1-$}value)

will sum all values exceept current selections

$ represent current selection

hope this helps you

Set Analysis exclusion on all fields from a particular table

Thu, 26 Jan 2012 14:14:54 GMT

Hi everyone, thanks for the help and sorry for the late reply. What I was refering to would be to exclude any selections made on any dimensions in a whole table. Would I have to enter all the fields one at a time?

Thanks again for all the help