Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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....
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.
Hi,
Please can you apply your solution to the example I gave?
Thank you
Please upload example data.
Rainer
Does this help?
// ---------------------------------------------------------------------
=Count({$<Type={'MT Pipeline'},[Max Review Reason]-={'Accepted'}>}Case)
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
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!
My final try:
=Count({$<[Max Review Season]-={$(=Accepted)},Type={'MT Pipeline'}>}Case)
Bah - good try James, I thought you'd cracked it, but then saw a record with 'Accepted' pulling through!