Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
asdavis
Contributor
Contributor

Set Analysis - Count specific value while excluding others

In my data set I am trying to count ID (field) using a specific  Document Type (field) of Instruction (value) but need to exclude any values that have a  Status (field) of Effective (value) and an Action (field) of either Cancel (value) OR Transfer (value).  

Currently I have the following set analysis that I am using to count a total of all documents regardless of type but with the exclusions.  Where/how do I add the Document Type specifications into the set analysis?

=count({1}{-(1<Status={'Effective'}>*1<Action={'Cancel','Transfer'}>)} ID) 

 

Labels (3)
1 Solution

Accepted Solutions
GaryGiles
Specialist
Specialist

Based on your description, try this:

=count({1<[Document Type]={'Instruction'}>-<Status={'Effective'},Action={'Cancel','Transfer'}>} ID)

View solution in original post

2 Replies
GaryGiles
Specialist
Specialist

Based on your description, try this:

=count({1<[Document Type]={'Instruction'}>-<Status={'Effective'},Action={'Cancel','Transfer'}>} ID)

asdavis
Contributor
Contributor
Author

Thank you so much!  That worked!   I knew I was probably botching my syntax.