Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Direct Discovery Script is not working in 11.2 SR5


Hi Forums,

I had sqlserver database and QV 11.2 SR5. Where I had table named as test_users Table with 2 column i.e. Firstname, Surname.

In Edit Script after doing the Database Connection. Following script is written which is working fine as follows:-

Tab1:

Sql Select FirstName, LastName from test_users;

Now I want to implement the Direct Discovery Functionalty. So, I had written the following script. as follows in script editor:-

Tab1:

DIRECT Select FirstName, LastName from test_users;

Which is not runing. Showing as Syntex errow Msg which is as follows:-

Syntax error.

tab1:

Direct Select FirstName, LastName from test_users

.

Can anybody please check and tell me where I am wrong. Please help me.

Advance Thanks

SD

5 Replies
MVP
MVP

Re: Direct Discovery Script is not working in 11.2 SR5

Do you have one of those fields (FirstName or LastName) in the normally loaded portion of the model? These values look like dimension values - do you really need DD for that?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Direct Discovery Script is not working in 11.2 SR5

Hi Jonathan,

Yes, I want. Can you please show the way out.

Thanks

SD


MVP
MVP

Re: Direct Discovery Script is not working in 11.2 SR5

You have not really answered my questions, so I cant really help you.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Direct Discovery Script is not working in 11.2 SR5

Hi Jonathan,

Apology, I may not given the answer to your question.

But my aim is to implement the functionalty of DD. Can you please provide/guide on DD with simple/example by QVW file.

Thanks

SD

Re: Direct Discovery Script is not working in 11.2 SR5

Community Browser