Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
jdmarlin
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
vishsaggi
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
vishsaggi
Esteemed Contributor III

Re: Possible and Exclude in Set Analysis

Try this?

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

vishsaggi
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
MVP

Re: Possible and Exclude in Set Analysis

Try

=Concat(

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

DISTINCT Product,',')

jdmarlin
New Contributor III

Re: Possible and Exclude in Set Analysis

It worked! Thanks!