Qlikview Direct Discovery

[sat_tok52]

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

[Anonymous]

may be helpful for you?

Direct Discovery in Qlikview

QlikView 11.2 and Direct Discovery

[jagan]

Hi,

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

Regards,

Jagan.

[Anonymous]

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