topic Validate all values in an input box in QlikView

Validate all values in an input box

j_nlucas — Fri, 09 Oct 2015 10:51:20 GMT

Hello,

I've got an input box where the user will introduce a list of values that I will filter in some field.

The values must be numbers with two decimals maximum and they'll be separated by the symbol "|". So an example of a correct entry would be:

4565.34|445|125543.56|90

and an example of a wrong entry would be:

4565.34|445|125543.56|90.776 or d4565.34|445|125543.56|7aab....

I know how to check if one item of the list meets the conditions, but I don't know how to iterate it to all items in the list.

Any idea?

petter — Fri, 09 Oct 2015 12:10:24 GMT

You can use this expression to give a true or false value depending on whether each list value is a number or not

so it is easy to extend from there:

=$(=Concat( 'IsNum(''' & SubField( vInputVar ,'|' , ValueLoop(1,SubStringCount(vInputVar,'|')+1)) & ' '')', ' AND ' ))

It can be generalized into a "function-variable" by using parameters too...

j_nlucas — Fri, 09 Oct 2015 12:59:30 GMT

I found a solution that is good enough:

=(len($)>0 and len(purgechar($,'0123456789.|')) = 0 and index($,'..')=0) or len($)=0