Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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?