topic Set Analysis - Omit Selections from Specific Field in QlikView

Set Analysis - Omit Selections from Specific Field

microwin88x — Thu, 23 Jan 2014 17:57:31 GMT

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!!

Re: Set Analysis - Omit Selections from Specific Field

Nicole-Smith — Thu, 23 Jan 2014 17:58:18 GMT

sum({<Category=>}Sales)

Re: Set Analysis - Omit Selections from Specific Field

Clever_Anjos — Thu, 23 Jan 2014 18:10:00 GMT

SUM ({<FieldWantOmit=>}Sales)

Re: Set Analysis - Omit Selections from Specific Field

Fri, 24 Jan 2014 08:47:14 GMT

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

Re: Set Analysis - Omit Selections from Specific Field

brijesh1991 — Fri, 24 Jan 2014 09:37:47 GMT

nullify that particual field

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

where we have ignored selection in ABC field