Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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