Help! Does Not Equal in Set Analysis

[#1]

Hi - I am trying to exclude 'Accepted' from my end results table.

I have tried the following (whch isn't working for me:

Count({$<Type = {'MT Pipeline'}, [Max Review Reason] ={'*'}-{'Accepted'}>}Case)

In addition, I have also tried to use the -= function, but this doesn't work for me either...

Please can someone advise?

Thanks

[#2]

Hi - this doesn't work for me either 😞

When I use Count({$<Type = {'MT Pipeline'}, [Max Review Reason] = {'Accepted'}>}Case) - I can see results, so can't understand why putting in the -= doesn't work for me....

[#3]

try to use exclude keyword in set analysis

Indirect Set Analysis

• p( ) = Possible

• e( ) = Excluded

example--

sum({$<CompanyName = p({$<CategoryName={'Baby Clothes'}>}

CompanyName)>} Sales)

Sales for Customers who purchased Baby Clothes.

The set p({}) returns the values of CompanyName (Customer) that

purchased Baby Clothes.

[#4]

Hi,

Please can you apply your solution to the example I gave?

Thank you

[#5]

Please upload example data.

Rainer

[#6]

Does this help?

// ---------------------------------------------------------------------

=Count({$<Type={'MT Pipeline'},[Max Review Reason]-={'Accepted'}>}Case)

[pennetzdorfer]

Please replace

[Max Review Reason] ={'*'}-{'Accepted'}

with

[Max Review Reason] -={'Accepted'}

(note the minus just before the equal sign)

Qlikview will show a syntax error (red underlined) but generally -= is allowed!

Hope that works!

Regards,

Florian

[#8]

Hi - again, thanks for all the suggestions:

So far I have tried the following:

Count({$<Type = {'MT Pipeline'}, [Max Review Reason] ={'*'}-{'Accepted'}>}Case)

Count( {$<[Max Review Reason] = E({1<[Max Review Reason] ={'Accepted'}>}[Max Review Reason] ),Type = {'MT Pipeline'}>}Case)

Count({$<Type={'MT Pipeline'},[Max Review Reason]-={'Accepted'}>}Case)

When I use the following expression, I can see data (both Accepted and non accepts)

Count({$<Type = {'MT Pipeline'}>}Case)

When I use the following expression, it returns data showing accepted:

Count({$<Type = {'MT Pipeline'}, [Max Review Reason] = {'Accepted'}>}Case)

I'm struggling with flipping this to show me the cases that are non accepts.....very frustrating!

[#9]

My final try:

=Count({$<[Max Review Season]-={$(=Accepted)},Type={'MT Pipeline'}>}Case)

[#10]

Bah - good try James, I thought you'd cracked it, but then saw a record with 'Accepted' pulling through!