Direct Query Chart Error when making dimension selection

israq — Tue, 29 Jan 2019 03:13:36 GMT

Hi All,

I'm facing chart error when making dimension selection when using direct query.

No issue if the dimension is Integer but error with varchar data type.

Direct Query from MSSQL 2017

DIRECT QUERY
DIMENSION
CREATEDATE AS STORE_DATE,
COMPANY AS COMPANY,
DIVISION AS DIVISION,
INVOICENUMBER AS STORE_BILLNO
MEASURE
NETSALES AS STORE_NETSALES
FROM TABLE

topic Direct Query Chart Error when making dimension selection in QlikView

Direct Query Chart Error when making dimension selection