Custom connector and Direct Discovery

alex_nerush — Thu, 26 Feb 2015 07:41:08 GMT

Hello Guys! I've created custom simple connector and trying to use it with Direct Discovery. I've created DIRECT QUERY in script and has successfully loaded data. But in Chart i have no calulated data (my expression looks like SUM(Field) ).

My direct query looks like:

Direct Query

DIMENSION Id

MEASURE Field

From MyTable;

My connector recognise all sql requests. How columns should be named in response for sql query? what should i send in response for sql query recieved from Qlik? (I know about QVX format and have SDK documentation). Right now i send all data as i do it with sql select * from MyTable. But i have no result. What am i missing?

Re: Custom connector and Direct Discovery

alex_nerush — Thu, 26 Feb 2015 10:04:40 GMT

I've found solution for the problem. If you use MEASURE Field and aggregation function in a chart, you will need to specify valid type: QVX_SIGNED_INTEGER, QVX_UNSIGNED_INTEGER, QVX_IEEE_REAL.

In my case i've specified QVX_TEXT, so i have no valid result. That was the problem.

topic Custom connector and Direct Discovery in QlikView

Custom connector and Direct Discovery

Re: Custom connector and Direct Discovery