topic Re: Problem to run Scalar Function in QlikView in QlikView

Problem to run Scalar Function in QlikView

lylererger — Sat, 09 Jan 2016 08:24:58 GMT

Hi friends!

Help me to solve the next problem:

When I'm running SQL query using scalar function - all is working fine

But when I'm trying to extract data using that scalar function - QlikView writes OLEDB read failed

Why ? Help!

Thnx in advance...

Re: Problem to run Scalar Function in QlikView

petter — Sat, 09 Jan 2016 08:37:57 GMT

You should give your two calculated columns an alias which will help QlikView to accept them. QlikView need unique column names being passed from the SQL SELECT statement.

So modifying your SQL query to something like this should work well (the bolded part has to be added):

SQL

SELECT DG_CODE,

dbo... xxxxxxxxxxxxx AS Calc1,

dbo... yyyyyyyyyyyyy AS Calc2

FROM

zzzzzzzzzz

;

Re: Problem to run Scalar Function in QlikView

lylererger — Sat, 09 Jan 2016 08:40:59 GMT

Omg... Petter thanks.