Number Data

[QlikAngel]

Hi,

I have field in that i have numbers & Text Data..

I want only number data in application.

how to do it

Regards,

Mayuri

[alexandros17]

Give us more details please ...

Generally you can use string functions to take only a part of a string but I need to know the structure of your data

[MK_QSL · Accepted solution]

Load * From YourFileName

Where IsNum(YourFieldName);

[datanibbler]

Hi Mayuri,

try the ISNUM() formula - that returns -1 when it is true (if the field_content is numeric), 0 otherwise.

HtH

[Anonymous]

Use the IsNum() function to filer out numbers only.