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: 
vsabbise
Creator
Creator

Count with Len() function and Greater than operator

 

Hi All,

I am planning to achieve something similar to below. Count distinct ID based on length of text > = 1

count({$<len([text])={">=1"} >} distinct ID)

The expression doesn't yield any result and I am not sure why.

Labels (2)
1 Reply
CarlosAMonroy
Creator III
Creator III

Hi, 

 

Maybe you can try this:

 

if(len(text)>0,count(Distinct ID) )

 

Hope that helps,

Carlos M