"?" symbol displayed in list box instead of field values

[chaitanyajami]

Hi,

i have filed name as Territary number where in data source all filed values are reflecting fine but in qlikview list box i could see some of Territary numbers are displayed as "?" symbols , please suggest what could be the issue.

Please find attached details

[Kushal_Chawda]

may be try this

=if(istext([Territory Number],[Territory Number], num([Territory Number]) as [Territory Number]

or

=if(istext([Territory Number],[Territory Number], text([Territory Number]) as [Territory Number]

or

text([Territory Number])

[tamilarasu]

Hi,

See below link,

Multiple Question mark in list box

[sujeetsingh]

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

[SlimJim]

My question mark field included only numbers. Transfer to number format helped. Sample "num(Field)" in table column definition.

[AshutoshBhumkar]

Hi,
Try using Text([Territory Number])

Thanks,
Ashutosh