Load Data From SQL

MK_QSL — Wed, 06 Nov 2013 10:52:30 GMT

OLEDB CONNECT32 TO ******

LOAD BRCODE,
      DECDDT,     //This is Timestamp in format ‘YYYY-MM-DD 00:00:00 000’
      DECDTIME,
      ORDNO,
      IVNO,
      IVDT,
      SR,          //Supplier
      PNO,
      PURQTY,
      PURAMT,
      CURR,
      CREAID,
      REFERENCE,
      BRNO,
      ORDTYPE;
SQL SELECT *
FROM PPMSDB1.dbo."PMS_PURCHASE";

1) How to write below SQL code in QlikView Script?

Select BRCODE, SR, SUM(PURAMT) From PMS_PURCHASE

Where (BRCODE = '123') and (DECDDT >= '2013-11-01')

Group By SR, BRCODE

Order By SUM(PURAMT) DESC

2) How can I convert DECDDT in ‘DD/MM/YYYY’

Re: Load Data From SQL

Gysbert_Wassenaar — Wed, 06 Nov 2013 10:56:18 GMT

Try date(date#(left(DECDDT,10),'YYYY_MM_DD'),'DD/MM/YYYY')

topic Re: Load Data From SQL in QlikView

Load Data From SQL

Re: Load Data From SQL