topic Re: Direct Discovery Ending with error in QlikView

Direct Discovery Ending with error

hariprasadqv — Wed, 01 Jul 2015 09:04:08 GMT

Hi All,

I'm testing Direct Discovery for one my app. Here is my code. can you please mark the defect in that

DIRECT QUERY

DIMENSION

Country,

`KPI Name`

MEASURE

`Value KPI`

FROM `Internal_Performance`;

I'm loading data from .mdb file through OLEDB connection.

Thanks in Advance

Re: Direct Discovery Ending with error

antoniotiman — Wed, 01 Jul 2015 09:25:20 GMT

Hi,

Try to use

Native('KPI Name') as "KPI Name"

and

Native('Value KPI') as "Value KPI"

Regards,

Antonio

Re: Direct Discovery Ending with error

hariprasadqv — Wed, 01 Jul 2015 09:37:19 GMT

Hi,

Here is the code and Error

DIRECT QUERY

DIMENSION

"Country",

NATIVE('KPI Name') as "KPIname"

MEASURE

NATIVE('Value KPI') as "ValueKPI"

FROM "Internal_Performance";

Thanks

Re: Direct Discovery Ending with error

antoniotiman — Wed, 01 Jul 2015 09:55:52 GMT

Remove " from Country and Internal_performance

Re: Direct Discovery Ending with error

hariprasadqv — Wed, 01 Jul 2015 09:58:37 GMT

OOOps. still issue remains.

Re: Direct Discovery Ending with error

skharlapenko — Wed, 05 Aug 2015 13:52:26 GMT

by doing this: `KPI Name` do you want to receive a string "KPI Name" or a column named "KPI Name". If the former, then you don't have enough quotes, if the latter then in case of MDB - it's NATIVE('"KPI Name"') or NATIVE('[KPI Name]')