Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
skzwane01
Contributor III
Contributor III

Qlikview dropping off values in a field

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:

skzwane01_0-1605771284171.png

 

QV result:

skzwane01_1-1605771323833.png

 

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

Thanks

Labels (1)
3 Replies
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.

Thanks & Regards,
Mayil Vahanan R
skzwane01
Contributor III
Contributor III
Author

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

Thanks & Regards,
Mayil Vahanan R