Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 .
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)
Hi Rohan,
Indeed I could do, but I want to learn how to do this in Chart side.
Perfect