topic Re: Help! Does Not Equal in Set Analysis in QlikView

Help! Does Not Equal in Set Analysis

Tue, 30 Jul 2013 11:57:13 GMT

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

Re: Help! Does Not Equal in Set Analysis

Tue, 30 Jul 2013 12:02:25 GMT

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

Tue, 30 Jul 2013 12:07:07 GMT

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

Tue, 30 Jul 2013 12:20:14 GMT

Hi,

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

Thank you

Re: Help! Does Not Equal in Set Analysis

Tue, 30 Jul 2013 13:37:18 GMT

Please upload example data.

Rainer

Re: Help! Does Not Equal in Set Analysis

Tue, 30 Jul 2013 13:53:31 GMT

Does this help?

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

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

Re: Help! Does Not Equal in Set Analysis

pennetzdorfer — Tue, 30 Jul 2013 13:54:44 GMT

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

Re: Help! Does Not Equal in Set Analysis

Tue, 30 Jul 2013 14:51:29 GMT

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

Tue, 30 Jul 2013 14:56:20 GMT

My final try:

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

Re: Help! Does Not Equal in Set Analysis

Tue, 30 Jul 2013 15:01:08 GMT

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

Tue, 30 Jul 2013 15:02:07 GMT

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

Re: Help! Does Not Equal in Set Analysis

pennetzdorfer — Tue, 30 Jul 2013 15:03:17 GMT

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

Wed, 11 Dec 2013 06:53:14 GMT

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

jagan — Wed, 11 Dec 2013 07:15:02 GMT

Hi,

Try like this

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

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

Regards,

Jagan.