Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ezther1997
Contributor
Contributor

Error in set modifier expression

Can somebody help me solve this error:

count({<[Actual Door Arrival] = {'0'} and <[Actual Invoice] -= {'0'}>} distinct[Sales Document])

"Error in set modifier expression"

 

I want to count the distinct Sales Documents that do not have an Actual Door Arrival date but do have an Actual Invoice date.

Labels (2)
1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

use a comma , instead of the "and"

 

View solution in original post

4 Replies
Chanty4u
MVP
MVP

try this expression

count({<[Actual Door Arrival] = {'0'} and [Actual Invoice] -= {'0'}>} distinct [Sales Document])

Ezther1997
Contributor
Contributor
Author

This gives me the same error

hic
Former Employee
Former Employee

use a comma , instead of the "and"

 

Ezther1997
Contributor
Contributor
Author

Thank you for the help!