Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Field Expression (11 digit numbers problem)

Hi;

I would like to see just 11 digit numbers in my field and i try in field expressionif(<field_name> > 10, <field_name>) and my app slow down after that. Also it does not work correctly.

Perhaps it is simple but i did not success...

Please Help me !!!

Thanks in advence

1 Solution

Accepted Solutions
Not applicable

Field Expression (11 digit numbers problem)

Hi Selcuk,

try the following: If(Len(YourField)>10, YourField)

Good luk!

Rainer

7 Replies
sparur
Valued Contributor II

Field Expression (11 digit numbers problem)

Do You want change number format ? or Do you want select only values more than 10?

Not applicable

Field Expression (11 digit numbers problem)

I want to select only values more than 10

Not applicable

Field Expression (11 digit numbers problem)

I want to select only values more than 10

Not applicable

Field Expression (11 digit numbers problem)

Hi Selcuk,

try the following: If(Len(YourField)>10, YourField)

Good luk!

Rainer

Not applicable

Field Expression (11 digit numbers problem)

Thank you Rainer ;

It works but that field is slower than other fields?

Do you know what is the reason of that?

MVP
MVP

Field Expression (11 digit numbers problem)

Well, if you're just doing that in the application instead of in the script, it has to execute a bunch of logic every time you use that expression. If that's the problem, I'd create it as a real field in the script:

if(len(YourField)>10,YourField) as YourFieldWithMoreThanTenDigits

And then use the new field instead any time you only want to see it when it has more than ten digits.

Not applicable

Field Expression (11 digit numbers problem)

Yes that is it...

This solving is what i need. Thank you so much...

Community Browser