Discussion Board for collaboration on QlikView Scripting.
I have a field, and it should just contain numbers - however due to the data structure it possible that the field contains text. If so, I want to be able to mark and/or filter these rows.
Go to Solution.
Use IsNum()/IsText() functions
with isnum(). for example:
load Value, isnum(Value) as IsNum inline [
Just as amit ray and Alejandro Hernandez suggest, you can use IsNum().
However, if you have texts like '3E4', these will be marked as TRUE by IsNum(), since it is a correct scientific numeric format. If you have such texts, it may be better to use