Load Distinct Issue in Qlikivew 11 server

qlik_venu — Mon, 14 Oct 2013 09:56:21 GMT

Hi,

We are in the process of moving dashbaords from Qlikview 10 to Qlikview 11.

There is a dashboard in which we are having a mismatch in data.

Qlikivew data test results

Qlikview 10 : Existing data

Qlikview 11 Reload from Server : Doesnt match with existing data

Qlikview 11 Reload from client : Matches the existing data ( Qlikview 10).

I checked the log files from Qlikview 11 Client and Qlikview 11 Server.

Qlikview 11 Client log matches exactly with Qlikview 10 Server reload.

We are using a link table. and there are 2 fact tables and lots of dimensions tables . In FACT tables, One is Order fact and other is appointments Fact.

What i observer is in the Appointments Fact, the number of rows which are getting added are differing in the Qlikviw 11 client reload and Qlikview 11 server reload.

The appoinment facts is not distinct, but atleast we must stay with the same rows as which are getting reloaded in the Client.

Can you please chck this and suggest me what might be going on here.

Thanks,

Venu

The Log file text from Qlikview Server 11 log and Qlikview 11 client ( same as qlikview 10).

Qlikview 11 Server reload log file below

First FACT table get loaded fine and after that as below,

14.10.2013 03:59:28:       Joining/Keeping
14.10.2013 03:59:30: 0444 Outer Join
14.10.2013 03:59:30: 0445
14.10.2013 03:59:30: 0446 LOAD distinct
14.10.2013 03:59:30: 0447
14.10.2013 03:59:30: 0448   Appointments_CustomerID_CRM As %CustomerID_CRM,
14.10.2013 03:59:30: 0449   Appointments_CustomerID_GPS As %CustomerID_GPS,
14.10.2013 03:59:30: 0450   Appointments_CustomerID_GPS_Group As %CustomerID_GPS_Group,
14.10.2013 03:59:30: 0451   Appointments_SalesManagerID_GPS As %SalesManagerID_GPS,
14.10.2013 03:59:30: 0452      Appointments_Date As %Date,
14.10.2013 03:59:30: 0453      Appointments_RegionID As %RegionID,
14.10.2013 03:59:30: 0454      %AppointmentsID
14.10.2013 03:59:30: 0455 RESIDENT Appointments
14.10.2013 03:59:30:        7 fields found: %CustomerID_CRM, %CustomerID_GPS, %CustomerID_GPS_Group,

%SalesManagerID_GPS, %Date, %RegionID, %AppointmentsID, 131,663 lines fetched
14.10.2013 03:59:31: Joining/Keeping

The same obsevred in Qlikview 11 client is,

14.10.2013 03:51:05: Joining/Keeping

14.10.2013 03:51:09: 0444 Outer Join

14.10.2013 03:51:09: 0445

14.10.2013 03:51:09: 0446 LOAD distinct

14.10.2013 03:51:09: 0447

14.10.2013 03:51:09: 0448 Appointments_CustomerID_CRM As %CustomerID_CRM,

14.10.2013 03:51:09: 0449 Appointments_CustomerID_GPS As %CustomerID_GPS,

14.10.2013 03:51:09: 0450 Appointments_CustomerID_GPS_Group As %CustomerID_GPS_Group,

14.10.2013 03:51:09: 0451 Appointments_SalesManagerID_GPS As %SalesManagerID_GPS,

14.10.2013 03:51:09: 0452 Appointments_Date As %Date,

14.10.2013 03:51:09: 0453 Appointments_RegionID As %RegionID,

14.10.2013 03:51:09: 0454 %AppointmentsID

14.10.2013 03:51:09: 0455 RESIDENT Appointments

14.10.2013 03:51:10: 7 fields found: %CustomerID_CRM, %CustomerID_GPS, %CustomerID_GPS_Group, %SalesManagerID_GPS, %Date, %RegionID, %AppointmentsID, 131,770 lines fetched

131 663 : is the distcint rows in the selected columns

131 770 : is the total rows of the appointments table.

topic Load Distinct Issue in Qlikivew 11 server in QlikView

Load Distinct Issue in Qlikivew 11 server