Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Qlikview, for some reason, shows squares instead of carriage-return. I'm reading an access database (.mdb) using ODBC driver.
Any ideas how to solve this?
See illustrations below:
:
Hi,
I recently came across the same issue, with the squares.
I used the REPLACE function to fix this. - See attached.
Thanks.
Hi,
I recently came across the same issue, with the squares.
I used the REPLACE function to fix this. - See attached.
Thanks.
You could also use an expression something like this:
replace([acc_dsc],'','
')
That will replace the square with a real new-line in your chart. You will need to change chart Properties on the Presentation tab, Multi-line Settings, to make the cells wrap to two lines.
Thanks for the Demo.
It turned out it was tab character (char(9)). Simple REPLACE did the trick.
Dror