Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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 (4)
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)

View solution in original post

asdavis
Contributor
Contributor
Author

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