Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Ragnar
Contributor II
Contributor II

Exclude Value (selections) in Expression

Hi Community,

I'm unable to resolve what the error is in this expression as I get a 'Error in set modifier expression':

=count({<Status-={'Dead Enquiry'} Status, transferred={"-1"},Year={2021}>}EF_No)

Purpose of the expression is:

Count the Number of EF_No (Enquiry Number) whilst Excluding 'Dead Enquiry' in the Year 2021 with the orders that have been transferred which is -1 (true)

I wish to see all orders that have Won excluding those have loss i.e. dead enquiry. 

I tried another expression: 

count({$<Status-={'Dead Enquiry'}>} Status) AND transferred=-1 AND Year=2021 and EF_No

which was OKAY but didn't produce any values.

 

Any guidance on where I'm going wrong is appreciated. 

 

Thanks for your time.

 

Labels (2)
2 Solutions

Accepted Solutions
Anil_Babu_Samineni

Perhaps this?

count({$<Status-={'Dead Enquiry'}, transferred={'-1'}, Year={'2021'}, EF_No=>} Status)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

hic
Former Employee
Former Employee

Remove the 'Status':

=count({<Status-={'Dead Enquiry'} Status, transferred={"-1"},Year={2021}>} EF_No)

View solution in original post

3 Replies
Anil_Babu_Samineni

Perhaps this?

count({$<Status-={'Dead Enquiry'}, transferred={'-1'}, Year={'2021'}, EF_No=>} Status)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
hic
Former Employee
Former Employee

Remove the 'Status':

=count({<Status-={'Dead Enquiry'} Status, transferred={"-1"},Year={2021}>} EF_No)

Ragnar
Contributor II
Contributor II
Author

Both of you are legends, both expression work and can't believe it was something small as opposed to what I thought it would be.

Also, I'm shocked at the effcient response time, genuinely appreciate it. Thank you Anil & Henric.