Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.