topic Re: len() in qlikview in QlikView

len() in qlikview

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 10 Oct 2017 13:09:15 GMT

try this

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

MarcoARaymundo — Tue, 10 Oct 2017 13:09:52 GMT

Try

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

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

)

) as NewFiledLen

Chanty4u — Tue, 10 Oct 2017 13:17:30 GMT

check simple example here

jonathandienst — Tue, 10 Oct 2017 13:28:30 GMT

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 — Tue, 10 Oct 2017 13:33:50 GMT

in text box 1 expression

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

Another text box

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

regards

Pradosh