Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
bzim8481
Contributor
Contributor

Trouble pulling all records from SQL View

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 ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='th:mm:ss';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY th:mm:ss[.fff]';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

//ODBC CONNECT TO [Business Data - PROD] (UserId is proddta, Password is proddta);

ODBC CONNECT TO JDE (XUserId is EMeKSZFMWH, XPassword is DYdPKbcNPDZITZFOMLIcL);

WorkOrderMasterFile:

load

WADOCO as WorkOrder,

WARORN as SONumber,

WASRST as StatusCode,

WATYPS as TypeWo,

WAMMCU as Branch,

WASTRT as DateStart,

WASTRX as CompletionDate,

WALITM as ItemNumber,

WAITM as ItemNumberShort,

WAUOM as UOM,

WADL01 as WODescpription,

WASOBK as [F4801 UnitsQuanBackorHeld],

WASOCN as [F4801 UnitsQuantityCanceled],

WASOQS/10000 as [F4801 UnitsQuantityShipped],

WATRDJ as DateTransactionJulian,

WLMCU as WorkCenter,

WLDSC1 as WCDesc,

Round((WLRUNL*60)/3600,0.01) as [Std Run Time],

Round((WLSETL*60)/3600,0.01) as [Std Setup Time],

fpmaverage as pressspeed;

SQL SELECT *

FROM "JDE_PRODUCTION".dbo.VISION_MAINWOPULL;

TimeTrans:

Load

RowNo() as RowID,

WTDOCO as WorkOrder,

WTAN8 as EmployeeNumber,

WTMMCU as Branch,

WTMCU as WorkCenter,

//STATUS as ReasonCode,

WTPBTM as trans_begintime,

WTPETM as trans_endtime,

WTSHFT as shift,

If(Len(text(WTDGL))>5,

Date(MakeDate(1900 + (left(text(WTDGL),1) * 100) + mid(text(WTDGL),2,2)) + (right(text(WTDGL),3) - 1)),

Date(MakeDate(1000 + (left(text(WTDGL),1) * 100) + mid(text(WTDGL),1,2)) + (right(text(WTDGL),3) - 1))) as [Employee Work Date],

WTDGL as JulianWorkDate,

WTHRW / 100 as trans_hrs,

STATUS as timecode,

YAALPH as NameAlpha;

SQL SELECT *

FROM "JDE_PRODUCTION".dbo.VISION_WOTIMETRANS;

There are multple records of the TimeTrans table to each record in the WorkOrderMasterFile

4 Replies
Anil_Babu_Samineni

Can you debug using NoOfRows() and by help of Trace function whether how many records are fetching and try same with Oracle as well as you need.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
bzim8481
Contributor
Contributor
Author

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.

juraj_misina
Partner
Partner

So what exactly is the problem then? Can you post a screenshot, sample app or more detailed description of the issue?

Anil_Babu_Samineni

No, you can not do perform SQL Queries into Chart using Qlik platform. What are you trying?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)