I am working with pulling data from some SQL views and for some reason, some records are pulling in while some are not, or if they are, they are not displaying in my chart (some do though). Stuck to say the least.
SET TimestampFormat='M/D/YYYY th:mm:ss[.fff]';
//ODBC CONNECT TO [Business Data - PROD] (UserId is proddta, Password is proddta);
ODBC CONNECT TO JDE (XUserId is EMeKSZFMWH, XPassword is DYdPKbcNPDZITZFOMLIcL);
Great - thank you - I was able to verify that the count between the records pulled in the view and pulled into Qlikview are the same amount of records - so the problem i presume is in how I am creating the chart? I can see the records in the SQL View through a query but not in Qlikview.