topic Re: "?" symbol displayed in list box instead of field values in QlikView

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

chaitanyajami — Wed, 25 Nov 2020 16:16:04 GMT

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

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

Kushal_Chawda — Wed, 08 Jun 2016 06:54:28 GMT

may be try this

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

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

text([Territory Number])

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

tamilarasu — Wed, 08 Jun 2016 06:55:36 GMT

Hi,

See below link,

Multiple Question mark in list box

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

sujeetsingh — Wed, 08 Jun 2016 06:58:20 GMT

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

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

SlimJim — Wed, 03 Apr 2019 09:40:33 GMT

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

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

AshutoshBhumkar — Wed, 03 Apr 2019 09:45:04 GMT

Hi,
Try using Text([Territory Number])

Thanks,
Ashutosh