What do you mean "more than a value from a concatenation of numbers" ?
SubStringCount - counts the substrings
SubField - finction that returns the substring by its order number.
Also SubField coud be used in load statement without specifying the number of substring.
In this case it loads every substring as a different row (repeating the other field values)
Sorry, my question isn't complete, as per my previous post http://community.qlik.com/message/250222 I'd like to use Substing funcion to condition visibility, in this case i have a table with different columuns that, depending on a list of metric, compare total with other parameters. For example 'quantity" should be visible only when I select 'sum (Sales)' or 'sum(Profit)' not for Geographic info. My purpose is not to duplicate the same columns for every metrics.