Count with Set Analysis

[eduardo_dimperio]

Hi everyone,

I need to count a field only with len(field) =11, but I think that we can't use an expression on the first part of a set analysis .

COUNT({$<len(CNPJ)={11}>}DISTINCT CPF_CNPJ)

Thank you

[Vegar · Accepted solution]

Try

COUNT({$<CNPJ = {"=len(CNPJ)=11"}>}DISTINCT CPF_CNPJ)

[Rohan]

Hey,

Why don't you create a field in the back end that has the length of your field value & then use that in the Set Analysis Expression.

load

*,

len(Required Field) as length

from {your table};

Then in front end :

Count({$<length={11}>} distinct [required field])

Let me know if this works .

[AlexPolorotov]

Try to create a new calculated field in your data model: len(CNPJ) as field_len.   

And then in your set expressions you can use simple  set expression: 

COUNT({$<field_len={'11'}>}DISTINCT CPF_CNPJ)

[eduardo_dimperio]

Hi Rohan, 

Indeed I could do, but I want to learn how to do this in Chart side.

[eduardo_dimperio]

Perfect