topic Possible and Exclude in Set Analysis in QlikView

Possible and Exclude in Set Analysis

jdmarlin — Wed, 09 Nov 2016 20:45:40 GMT

I have the following table:

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!

vishsaggi — Wed, 09 Nov 2016 21:09:27 GMT

Try this?

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

vishsaggi — Wed, 09 Nov 2016 21:19:58 GMT

Sorry try this?

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

swuehl — Wed, 09 Nov 2016 21:44:43 GMT

Try

=Concat(

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

DISTINCT Product,',')

jdmarlin — Wed, 09 Nov 2016 21:48:08 GMT

It worked! Thanks!