Dimension values are coming as " ? " (question mark) in sheets instead of number format

[Mapuna]

Hello experts,

Kindly try to answer my question in the below link:

https://community.qlik.com/t5/QlikView-App-Dev/Dimension-values-are-coming-as-quot-quot-question-mar... 

[vinieme12]

This is because the same column has conflicting datatypes

for example first few rows loaded as NUMBERS and then subsequent data was loaded as TEXT

If you are confident all values are NUMBERS try to force the format as 

Num(FieldName) as FieldName

Try to verify there are no garbage characters or force numbers using keepchar()

keepchar(FieldName,'0123456789') as FieldName