Solved: Qlikview Direct discovery with small demo - Qlik Community

vikasmahajan · ‎2015-09-02

Dear all,

Any one have direct discovery demo with working solution , Please share .

Thanks in Adv

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

vikasmahajan · ‎2015-09-02

OLEDB CONNECT TO your_connection_string;

DIRECT QUERY

DIMENSION

[ACTION]

,[HNAME]

MEASURE

[VALUES]

FROM

[dbo].[TABLE_NAME];

additional set commands

SET DirectUnicodeStrings=TRUE;

SET DirectTableBoxListThreshold = 100000;

Worked for me thanks

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

View solution in original post

vikasmahajan · ‎2015-09-02

OLEDB CONNECT TO your_connection_string;

DIRECT QUERY

DIMENSION

[ACTION]

,[HNAME]

MEASURE

[VALUES]

FROM

[dbo].[TABLE_NAME];

additional set commands

SET DirectUnicodeStrings=TRUE;

SET DirectTableBoxListThreshold = 100000;

Worked for me thanks

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.