Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Please close the thread by marking correct answer & give likes if you like the post.
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
Please close the thread by marking correct answer & give likes if you like the post.