Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lylererger
Creator II
Creator II

Problem to run Scalar Function in QlikView

Hi friends!

Help me to solve the next problem:

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

1.png

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

2.png

Why ? Help!

Thnx in advance...

1 Solution

Accepted Solutions
petter
Partner
Partner

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

;

View solution in original post

2 Replies
petter
Partner
Partner

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

;

View solution in original post

lylererger
Creator II
Creator II
Author

Omg... Petter thanks.