Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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
h_prakash
Creator
Creator

Hi,

You cannot use a Function for the fields in the Set Analysis Expression. 

You can try something like this

If(Len(trim([text]))>=1, Count(Distinct ID).

 

Thanks

Prakash