Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help uploading the script

Hey everyone i am keep getting this error

11.40 03.12.2015.PNG

i have free space of about 16 GB on the disc that is running the following script:

//שע מטבע לתאריך החשבונית ולמטבע השורה

Left JOIN (INV_SALES_TEMP)

LOAD  

CUR_CURRENCY AS INV_CURRENCY,

CUR_EXCHANGE

Resident CURRENCIES;

LEFT JOIN (INV_SALES_TEMP)

LOAD

Date ( CURREG_CURDATE/60/24+32143,'DD/MM/YYYY')  AS INV_IVDATE,

CURREG_CURRENCY  AS INV_CURRENCY,

CURREG_EXCHANGE

Resident CURREG;

left JOIN (INV_SALES_TEMP)

LOAD   /*CUR_CURRENCY AS INV_CURRENCY ,*/

CUR_EXCHANGE AS CUR_EXCHANGE2

Resident CURRENCIES Where CUR_CURRENCY = -2;

LEFT JOIN (INV_SALES_TEMP)

LOAD Date ( CURREG_CURDATE/60/24+32143,'DD/MM/YYYY') AS INV_IVDATE ,

/*     CURREG_CURRENCY  AS INV_CURRENCY,*/

CURREG_EXCHANGE AS CURREG_EXCHANGE2

Resident CURREG Where CURREG_CURRENCY = -2;

Left JOIN (INV_SALES_TEMP)

LOAD  /* CUR_CURRENCY AS INV_CURRENCY ,*/

CUR_EXCHANGE AS CUR_EXCHANGE3

Resident CURRENCIES;

left JOIN (INV_SALES_TEMP)

LOAD

Date ( CURREG_CURDATE/60/24+32143,'DD/MM/YYYY') AS INV_IVDATE ,

/*    CURREG_CURRENCY  AS INV_CURRENCY ,*/

CURREG_EXCHANGE AS CURREG_EXCHANGE3

Resident CURREG;

// // LINE 183 IN THE SALES CHART//

LEFT JOIN (INV_SALES_TEMP)

LOAD

ACC_COSTFLAG,

DATE((NUM(MAX(ACC_COSTDATE)))/60/24+32143,'DD/MM/YYYY') AS MAXACC_COSTDATE

RESIDENT ACCDATES WHERE ACC_COSTDATE<>0

GROUP BY ACC_COSTFLAG;

DROP TABLE ACCDATES;

2 Replies
Chanty4u
MVP
MVP

check with the datamodel...if the data is cmg or not?

Not applicable
Author

cmg?