count mismatch

Thu, 09 Dec 2010 13:56:24 GMT

when i am trying to join two tables from database it's returns the following counts-

SELECT A.EVENT_DATE,b.CHRG_PROFILE_DESC ,SUM(A.APC_QUERY_NOT_OK_COUNT)
FROM SUMMARY_PCS A,TME_CHARGING_PROFILE B
WHERE A.CHARGING_PROFILE_TYPE_ID=B.CHRG_PROFILE_TYPE_ID
GROUP BY A.EVENT_DATE,b.CHRG_PROFILE_DESC

EVENT_DATE CHRG_PROFILE_DESC SUM(A.APC_QUERY_NOT_OK_COUNT)

10/31/2010 Bono 1
10/31/2010 Descarga 10849
10/31/2010 Paquete 104
10/31/2010 Sesión 117
10/31/2010 Suscripción 1321
11/01/2010 Bono 3
11/01/2010 Descarga 10022
11/01/2010 Paquete 76
11/01/2010 Sesión 101
11/01/2010 Suscripción 1236
11/02/2010 Bono 3
11/02/2010 Descarga 8304
11/02/2010 Paquete 61
11/02/2010 Sesión 98
11/02/2010 Suscripción 1078

but when i am trying it from qlik view it returns wrongs-------

i have attached print screen for this.

please find the edit script which defined

==================================

OLEDB CONNECT32 TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=tme;Data Source=OLISTADB_INT;Extended Properties=""] (XPassword is SFCSAaVNFLCA);

SUMMARY:
SQL SELECT a.* FROM summary_pcs a;

//store Qlikview Table from memory to disk

store SUMMARY into E:\qlikview\SUMMARY.qvd (qvd);

LOAD
timestamp(EVENT_DATE,'DD/MM/YY') , CHARGING_PROFILE_TYPE_ID ,CONTENT_PROFILE_ID , CONTENT_ID ,sum(APC_QUERY_NOT_OK_COUNT)
FROM SUMMARY.QVD (QVD)
group by timestamp(EVENT_DATE,'DD/MM/YY') , CHARGING_PROFILE_TYPE_ID ,CONTENT_PROFILE_ID , CONTENT_ID ;

CHARGING_PROFILE:
LOAD CHARGING_PROFILE_TYPE_ID ,CHRG_PROFILE_DESC;
SQL SELECT CHRG_PROFILE_TYPE_ID CHARGING_PROFILE_TYPE_ID, CHRG_PROFILE_DESC FROM TME_CHARGING_PROFILE;

please let me know what is wrong here

topic count mismatch in QlikView

count mismatch