13 Replies Latest reply: Dec 11, 2013 2:15 AM by jagan mohan rao appala

# Help!  Does Not Equal in Set Analysis

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...

Thanks

• ###### Re: Help!  Does Not Equal in Set Analysis

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....

• ###### Re: Help!  Does Not Equal in Set Analysis

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.

• ###### Re: Help!  Does Not Equal in Set Analysis

Hi,

Thank you

• ###### Re: Help!  Does Not Equal in Set Analysis

Rainer

• ###### Re: Help!  Does Not Equal in Set Analysis

Does this help?

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

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

• ###### Re: Help!  Does Not Equal in Set Analysis

[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

• ###### Re: Help!  Does Not Equal in Set Analysis

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!

• ###### Re: Help!  Does Not Equal in Set Analysis

My final try:

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

• ###### Re: Help!  Does Not Equal in Set Analysis

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

• ###### Re: Help!  Does Not Equal in Set Analysis

might have to get an example document up... set expressions are always an exercise in frustration.

• ###### Re: Help!  Does Not Equal in Set Analysis

What results do you get, if you try James Wallers or my proposals?

Please post an example, that makes helping a lot easier

• ###### Re: Help!  Does Not Equal in Set Analysis

Hey guys - apologies for not getting back to you - I managed to get this to work!

However, I do have another problem and wondered if anyone could help - I have an expression in a straight line table ONLY({\$<Type = {'Hire Reject'}>}User), yet I want to move this to be a calculated dimension - however, when i do this, I receive the result //error in calculated dimension - even though it works as an expression...this is driving me nuts!

• ###### Re: Help!  Does Not Equal in Set Analysis

Hi,

Try like this

Aggr(If(Type = 'Hire Reject', User), User, Type)

or

just use Type = 'Hire Reject' in all you expressions in chart, calculated dimension has performance issues.

Regards,

Jagan.