Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

mikefromoke
Contributor II

SQL error converting data type varchat to float

Hi @all,

while trying a simple data load  from an sql-tableview i get this error from qv:

anyone an idea how to get rid of this message? i'm really no sql-expert, but there might be  a way to handle the datasets , maybe with a "convert" or something like that..

any sql-experts?

regards

1 Reply

Re: SQL error converting data type varchat to float

Hi,

It is query issue.

Is the above query run properly in your sql editor

If your using SQL server db then look convert() and cast() might help you.

Regards,

Prashant

Great dreamer's dreams never fulfilled, they are always transcended.