LOAD fieldvalue('SomeField',recno()) as SomeField AUTOGENERATE fieldvaluecount('SomeField');
It seems in this case that QlikView isn't sure what sort of formatting to apply by default, and ends up applying NO formatting sometimes, resulting in the question marks. Or maybe it's applying different formatting in different tables. In this case, explicitly telling it a format was the solution, kind of the opposite of Jonathan's case. In both cases, though, the problem seems to be confusion in the product about what format to use.
I am also facing the same problem in my List Box . When i open the same Fields individually by commenting other tables i am getting the Fine data with " no Question mark " . But when i combine all those tables into one ,i find the Question mark in one of my Key field in list box and in preview . I have not used anything like ' Text ' as was there before and it was normal.
Please suggest me what was the problem and what can be done to filter them ?