topic Field Expression (11 digit numbers problem) in QlikView

Field Expression (11 digit numbers problem)

Thu, 01 Jul 2010 08:43:44 GMT

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

Field Expression (11 digit numbers problem)

sparur — Thu, 01 Jul 2010 08:58:57 GMT

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

Field Expression (11 digit numbers problem)

Thu, 01 Jul 2010 09:01:20 GMT

I want to select only values more than 10

Field Expression (11 digit numbers problem)

Thu, 01 Jul 2010 12:05:48 GMT

I want to select only values more than 10

Field Expression (11 digit numbers problem)

Thu, 01 Jul 2010 12:21:56 GMT

Hi Selcuk,

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

Good luk!

Rainer

Field Expression (11 digit numbers problem)

Thu, 01 Jul 2010 13:03:05 GMT

Thank you Rainer ;

It works but that field is slower than other fields?

Do you know what is the reason of that?

Field Expression (11 digit numbers problem)

johnw — Thu, 01 Jul 2010 22:04:10 GMT

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.

Field Expression (11 digit numbers problem)

Fri, 02 Jul 2010 09:10:08 GMT

Yes that is it...

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