Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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