len() in qlikview

[bhavvibudagam]

Hi Everyone,

I have one field contains different number of characters records.

From Name field I need to calculate

1. count of Number of characters which are less than 4

2. count of Number of characters which are greater than 6

I have taken len(Name) in text object by selecting each record i am able to see the count. But to get <4 characters count how to write the syntax.

Thanks in Advance.

[Chanty4u]

try this

If(Len(FIeld) <4,1,0) as new

[MarcoARaymundo]

Try

If(Len(Field) < 4, Len(Field),

    If(Len(Filed) >6, Len(6),

          ''

    )

)                                             as NewFiledLen

[Chanty4u · Accepted solution]

check simple example here

length function | Qlik Community

[jonathandienst]

In the front end or in the script?

If  the former, depending on the context:

Sum(If(Len(Name) < 4, 1, 0))

and

Sum(If(Len(Name) > 6, 1, 0))

[pradosh_thakur]

in text box 1 expression

=count({<[Name]= {"=len([Name])<4"} >} DISTINCT [Name])

Another text box

=count({<[Name]= {"=len([Name])>6"} >} DISTINCT [Name])

regards

Pradosh