Qlikview dropping off values in a field

[skzwane01]

Good day,

I am connecting to a SQL datasource. When I run the SQL script all is well and I can see the values. When I run the same script on QV it is dropping off values in a field.

Please see below examples:

SQL result:

QV result:

Please advise what could be causing the issue ? What is that I need to do ?

Thanks

[MayilVahanan]

Hi @skzwane01 

Might be, its double line values in SQL.

If you mouse over the values in QV, might be, it will visible complete words.

[skzwane01]

Hi MayilVahanan,

Thank you for your response. You are 100% correct. I have increased the wrap text cell height to 2 lines and the data is there. How do I go about making the data into one line ?

Kind Regards,

[MayilVahanan]

Hi @skzwane01 

Try like below

Replace(MP_PDP_LEARNING,chr(10),'') as MP_PDP_LEARNING