topic Re: Qlikview Direct Discovery in QlikView

Qlikview Direct Discovery

sat_tok52 — Mon, 01 Feb 2016 07:08:21 GMT

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 — Mon, 01 Feb 2016 07:11:47 GMT

may be helpful for you?

jagan — Mon, 01 Feb 2016 07:20:08 GMT

Hi,

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

Regards,

Jagan.

Anonymous — Mon, 01 Feb 2016 07:37:01 GMT

You have to update your current statement

Direct SELECT *

FROM dbo.Agents;

Direct SELECT

Dimension

Dim1,

Dim2,

Measure

Mes1

.....

FROM dbo.Agents;

Where Dimension & Measure are keywords for your Direct Query