# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Highlighted
New Contributor III

## Possible and Exclude in Set Analysis

I have the following table:

ProductCategoryCost
AX0
AY10
BY-10
BZ10
CX0
CY-10

I'm trying to filter the results as:

Products that have

1) Category equal to X

2) Does not have Category equal to Y and Cost greater than 0

So only product C meets those requirements. Product C has Category X and does not have Category Y where cost is greater than 0.

So I've tried:

Sum({< Product=P({< Category={'X'} >}), Product=E({< Category={'Y'}, Cost={">0"} >}) >} Revenue)

Any help greatly appreciated!

Tags (2)
1 Solution

Accepted Solutions
Esteemed Contributor III

## Re: Possible and Exclude in Set Analysis

Sorry try this?

= Sum({< Product = P({< Category = {'X'}, Product = E({< Category = {'Y'}, Cost = {'>0'} >})>}) >} Revenue)

4 Replies
Esteemed Contributor III

## Re: Possible and Exclude in Set Analysis

Try this?

= Sum({< Category = {'X'} , Product = E({< Category= {'Y'}, Cost = {'>0'} >}) >} Revenue)

Esteemed Contributor III

## Re: Possible and Exclude in Set Analysis

Sorry try this?

= Sum({< Product = P({< Category = {'X'}, Product = E({< Category = {'Y'}, Cost = {'>0'} >})>}) >} Revenue)

MVP

## Re: Possible and Exclude in Set Analysis

Try

=Concat(

{<Product=P({< Category={'X'} >})*E({< Category={'Y'}, Cost={">0"} >}) >}

DISTINCT Product,',')

New Contributor III

## Re: Possible and Exclude in Set Analysis

It worked! Thanks!