Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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