Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
girino777
Creator III
Creator III

Saber se Coluna é String ou Numérico

Bom Dia.!

Existe alguma função para saber se a coluna de uma tabela contem dados string ou numérico ?

Muito Obrigado

Renato

1 Solution

Accepted Solutions
maxgro
MVP
MVP

try these (copied from QlikView help)

IsNum( expr)

Returns -1 (true) if the expression can be interpreted as a number, otherwise 0 (false).

IsText(expr)

Returns -1 (true) if the expression has a text representation, otherwise 0 (false).

View solution in original post

2 Replies
maxgro
MVP
MVP

try these (copied from QlikView help)

IsNum( expr)

Returns -1 (true) if the expression can be interpreted as a number, otherwise 0 (false).

IsText(expr)

Returns -1 (true) if the expression has a text representation, otherwise 0 (false).

girino777
Creator III
Creator III
Author

OK.!

Muito Obrigado.!! 

Renato