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: 
Tarig
Contributor III
Contributor III

count if sum(value) is less than 0 or null in qlik sense

Hello

I am trying build a bar chart that count the number of people who delcared Zero income by year. below is the expression I used

If((sum(Income)) <= 0, Count (Distinct [PersonId]))

but I'm getting this error msg "The chart is not displayed because it contains only undefined value"

I tried this expression  as well but still no luck:

Count({<[PersonId]={"=Sum([Income]) <= 0 "}>} distinct [PersonId])

 

Labels (4)
2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Your set analysis expression looks correct. What error/result are you getting with that expression?

-Rob

Tarig
Contributor III
Contributor III
Author

I'm getting this error "The chart is not displayed because it contains only undefined value" when I add the first expression. the second expression is not returing any value.