Set Analysis - Omit Selections from Specific Field

[microwin88x]

Hello!

Is there any way in Set Analysis to omit the seleccions I make from a specific field?

For example, if my expression is SUM (Sales), if I select a value in the field category, don't recalculate the sum of sales for that field in particular. How could I do that?

Thanks!!

[Nicole-Smith]

sum({<Category=>}Sales)

[Clever_Anjos]

SUM ({<FieldWantOmit=>}Sales)

[#4]

Hi,

I have created a document on Set Analysis: http://community.qlik.com/docs/DOC-4951

It may help you.

The answer to yur question was in the 4.1 section (All members). But the answers by Nicole Smith and Clever Anjos are correct and perhaps sufficient.

Fabrice

[brijesh1991]

nullify that particual field

for example: sum({$<ABC=>}sales)

where we have ignored selection in ABC field