Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

sat_tok52
Contributor

Qlikview Direct Discovery

Hi Guru's,

How do i write direct query syntax on below sql query

SQL  SELECT *

FROM dbo.Agents;

I written like below it's throwing error.

Direct SELECT *

FROM dbo.Agents;

Thanks,

Sateesh.T

3 Replies
balrajahlawat
Esteemed Contributor

Re: Direct Discovery

MVP
MVP

Re: Qlikview Direct Discovery

Hi,

Refer Qlikview Help File (F1), there is lot of info and examples on this.  The syntax is bit different

Regards,

Jagan.

balrajahlawat
Esteemed Contributor

Re: Qlikview Direct Discovery

You have to update your current statement

Direct SELECT *

FROM dbo.Agents;

to

Direct SELECT

Dimension

Dim1,

Dim2,

Measure

Mes1

.....

FROM dbo.Agents;

Where Dimension & Measure are keywords for your Direct Query

Community Browser