Qlikview determines the column type and format from the first rows it loads for that field. QV presumably sees the Value column as numeric, and the failed numeric conversion of * will return a null. What do you want to do with it?
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein