Qlik Community

Qlik Sense App Development

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

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
vsabbise
New Contributor III

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.

1 Reply
CarlosAMonroy
Contributor III

Re: Count with Len() function and Greater than operator

Hi, 

 

Maybe you can try this:

 

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

 

Hope that helps,

Carlos M