topic Re: Qlikview dropping off values in a field in QlikView

Qlikview dropping off values in a field

skzwane01 — Fri, 15 Nov 2024 23:36:09 GMT

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

Re: Qlikview dropping off values in a field

MayilVahanan — Thu, 19 Nov 2020 08:01:56 GMT

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.

Re: Qlikview dropping off values in a field

skzwane01 — Thu, 19 Nov 2020 08:42:29 GMT

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,

Re: Qlikview dropping off values in a field

MayilVahanan — Thu, 19 Nov 2020 09:29:56 GMT

Hi @skzwane01

Try like below

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