Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Set analysys - "Not in"

Hello,

I´ve a table with customers and situation code (300 or 302). Some customers can have both situation code and others can have just one of them.

What are the expression that let me know which customers does have just one situation code? (300 or 302).

Thank you

1 Solution

Accepted Solutions
alfasierra
Contributor II

Re: Set analysys - "Not in"

Hi try this

sum({$<customer = p({$<code={'300'}>}

customer) - p({$<code={'302'}>}

customer)>} Sales)

4 Replies
Not applicable

Re: Set analysys - "Not in"

I need to know which customers have situation code=300 AND don´t have situation code=302

alfasierra
Contributor II

Re: Set analysys - "Not in"

Hi try this

sum({$<customer = p({$<code={'300'}>}

customer) - p({$<code={'302'}>}

customer)>} Sales)

Not applicable

Re: Set analysys - "Not in"

Hello Alfasierra,

This code above is working fine! Thank you.

Now... which is the expression to show me customers that have BOTH codes (300 and 302)?

Thank you

alexpanjhc
Valued Contributor

Re: Set analysys - "Not in"

try

sum({$<customer = p({$<code={'300'}>}

customer)* p({$<code={'302'}>}

customer)>} Sales)

Community Browser