Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

missing/misplaced FROM

Hey everyone i am getting the following erroe but i don't realiy understand the problem



Syntax error, missing/misplaced FROM: INV_SALES: LOAD CUST_CUST AS INV_CUST, INV_IVDATE AS IVDATE, INV_INVNUM, CUST_AGENTNAME AS INV_AGENTNAME, IV_AGENT, IV_BRANCH, INV_TYPE, IV_PART, TRANS_COST, IV_QUANT, IV_QUANT*IF(DEBIT ='C',-1,1) AS RIV_QUANT, IV_PERCENT, IV_COMMISSION, IV_IVCOST, (IF(ISNULL(IV_TRANS) =-1,0,IV_TRANS)) AS IV_TRANS, IV_CREDITFLAG, (IF(DEBIT='C',(-1),1)) AS IVCAL_CREDIT, (IV_IVCOST * (IF (DEBIT ='C',(-1),1)) * (IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3 = INV_CURRENCY,FNC_EXCHANGE3, if(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE ))))) AS NIS_TOTPRICE, (IV_IVCOST * (IF (DEBIT='C',(-1),1)) * (IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3=INV_CURRENCY,FNC_EXCHANGE3, IF(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE ))))) / IF(FNC_EXCHANGE2 > 0 , FNC_EXCHANGE2, IF(CURREG_EXCHANGE2 > 0 , CURREG_EXCHANGE2 , CUR_EXCHANGE2)) AS DOLLAR_TOTPRICE, נבדק לא פה השגיאה של הדי באגר (IV_IVCOST * (IF (DEBIT='C',(-1),1)) * (IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3 = INV_CURRENCY,FNC_EXCHANGE3, IF(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE ))))) / IF(CURREG_EXCHANGE3 > 0 , CURREG_EXCHANGE3 , CUR_EXCHANGE3) AS CURRENCY_TOTPRICE, CUST_CUST&'_'&IV_AGENT&'_'&IV_BRANCH&'_'&IV_PART&'_'&INV_IVDATE AS SALES_KEY RESIDENT INV_SALES_TEMP : INV_SALES: LOAD CUST_CUST AS INV_CUST, INV_IVDATE AS IVDATE, INV_INVNUM, CUST_AGENTNAME AS INV_AGENTNAME, IV_AGENT, IV_BRANCH, INV_TYPE, IV_PART, TRANS_COST, IV_QUANT, IV_QUANT*IF(DEBIT ='C',-1,1) AS RIV_QUANT, IV_PERCENT, IV_COMMISSION, IV_IVCOST, (IF(ISNULL(IV_TRANS) =-1,0,IV_TRANS)) AS IV_TRANS, IV_CREDITFLAG, (IF(DEBIT='C',(-1),1)) AS IVCAL_CREDIT, (IV_IVCOST * (IF (DEBIT ='C',(-1),1)) * (IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3 = INV_CURRENCY,FNC_EXCHANGE3, if(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE ))))) AS NIS_TOTPRICE, (IV_IVCOST * (IF (DEBIT='C',(-1),1)) * (IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3=INV_CURRENCY,FNC_EXCHANGE3, IF(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE ))))) / IF(FNC_EXCHANGE2 > 0 , FNC_EXCHANGE2, IF(CURREG_EXCHANGE2 > 0 , CURREG_EXCHANGE2 , CUR_EXCHANGE2)) AS DOLLAR_TOTPRICE, נבדק לא פה השגיאה של הדי באגר (IV_IVCOST * (IF (DEBIT='C',(-1),1)) * (IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3 = INV_CURRENCY,FNC_EXCHANGE3, IF(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE ))))) / IF(CURREG_EXCHANGE3 > 0 , CURREG_EXCHANGE3 , CUR_EXCHANGE3) AS CURRENCY_TOTPRICE, CUST_CUST&'_'&IV_AGENT&'_'&IV_BRANCH&'_'&IV_PART&'_'&INV_IVDATE AS SALES_KEY RESIDENT INV_SALES_TEMP

5 Replies
swuehl
MVP
MVP

Yes, can't see any FROM statement.

Could you please post your actually script statement, not the unformatted errror message, which is hard to read anyway.

In addition, what is

נבדק לא פה השגיאה של הדי באגר (IV_IVCOST * (IF (DEBIT='C',(-1),1)) * (IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3 = INV_CURRENCY,FNC_EXCHANGE3, IF(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE ))))) / IF(CURREG_EXCHANGE3 > 0 , CURREG_EXCHANGE3 , CUR_EXCHANGE3) AS CURRENCY_TOTPRICE,


supposed to do?

Not applicable
Author

just noticed it thanks! now for some reason i am getting this error:

Error in expression: ')' expected: INV_SALES: LOAD CUST_CUST AS INV_CUST, INV_IVDATE AS IVDATE, INV_INVNUM, CUST_AGENTNAME AS INV_AGENTNAME, IV_AGENT, IV_BRANCH, INV_TYPE, IV_PART, TRANS_COST, IV_QUANT, IV_QUANT*IF(DEBIT ='C',-1,1) AS RIV_QUANT, IV_PERCENT, IV_COMMISSION, IV_IVCOST, (IF(ISNULL(IV_TRANS) =-1,0,IV_TRANS)) AS IV_TRANS, IV_CREDITFLAG, (IF(DEBIT='C',(-1),1)) AS IVCAL_CREDIT, (IV_IVCOST * (IF (DEBIT ='C',(-1),1)) * (IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3 = INV_CURRENCY,FNC_EXCHANGE3, if(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE ))))) AS NIS_TOTPRICE, (IV_IVCOST * (IF (DEBIT='C',(-1),1)) * (IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3=INV_CURRENCY,FNC_EXCHANGE3, IF(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE ))))) / IF(FNC_EXCHANGE2 > 0 , FNC_EXCHANGE2, IF(CURREG_EXCHANGE2 > 0 , CURREG_EXCHANGE2 , CUR_EXCHANGE2)) AS DOLLAR_TOTPRICE, (IV_IVCOST * (IF (DEBIT='C',(-1),1)) * (IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3 = INV_CURRENCY,FNC_EXCHANGE3, IF(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE ))))) / IF(CURREG_EXCHANGE3 > 0 , CURREG_EXCHANGE3 , CUR_EXCHANGE3) AS CURRENCY_TOTPRICE, IF ((IsNull(TRANS_COST)=0 OR TRANS_COSTFLAG = 'M') OR (IV_TRANS <> 0 AND TRANS_CURDATE <=MAXACC_COSTDATE), TRANS_COST * (IF (TRANS_QUANT * IV_TQUANT < 0.0,(-1),1)), (IV_PART_COST * IV_QUANT / PART_COSTQUANT * (IF (DEBIT='C',(-1),1)) * (IF (IV_CREDITFLAG='Y',0,1)))) AS NIS_COST, IF ((IsNull(TRANS_SECONDCOST)= 0 OR TRANS_COSTFLAG = 'M') OR (IV_TRANS <> 0 AND TRANS_CURDATE <= MAXACC_COSTDATE), TRANS_SECONDCOST * (IF (TRANS_QUANT * IV_TQUANT < 0.0,(-1),1)), PART_SECONDCOST * IV_QUANT / PART_COSTQUANT * (IF (DEBIT ='C',(-1),1)) * (IF (IV_CREDITFLAG = 'Y',0,1))) AS DOLLAR_COST, (IF ((IsNull(TRANS_SECONDCOST)= 0 OR TRANS_COSTFLAG = 'M') OR (IV_TRANS <> 0 AND TRANS_CURDATE <= MAXACC_COSTDATE), TRANS_COST * (IF (TRANS_QUANT * IV_TQUANT < 0.0,(-1),1)), IV_PART_COST * IV_QUANT / PART_COSTQUANT * (IF (DEBIT ='C',(-1),1)) * (IF (IV_CREDITFLAG='Y',0,1))) ) / IF(CURREG_EXCHANGE3 > 0 ,CURREG_EXCHANGE3 , CUR_EXCHANGE3) AS CURRENCY_COST, (IV_DUTYCOST * (IF (DEBIT ='C',(-1),1)) * (IF((=1) AND IV_DUTYCOST <> 0,IV_IEXCHANGE,(IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3=INV_CURRENCY,FNC_EXCHANGE3, if(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE ))))))) AS NIS_DUTYCOST, CUST_CUST&'_'&IV_AGENT&'_'&IV_BRANCH&'_'&IV_PART&'_'&INV_IVDATE AS SALES_KEY RESIDENT INV_SALES_TEMP

Not applicable
Author

i got it for this script:

(IV_DUTYCOST * (IF (DEBIT ='C',(-1),1)) * (IF(($(vEXPORTEXCHANGE)=1) AND IV_DUTYCOST <> 0,IV_IEXCHANGE,(IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3=INV_CURRENCY,FNC_EXCHANGE3,

if(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE ))))))) AS NIS_DUTYCOST,

(IV_DUTYCOST * (IF (DEBIT = 'C',(-1),1)) * (IF(($(vEXPORTEXCHANGE) =1) AND IV_DUTYCOST <> 0,IV_IEXCHANGE,(IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3 = INV_CURRENCY,FNC_EXCHANGE3,

if(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE )))))))/ IF(FNC_EXCHANGE2 > 0 , FNC_EXCHANGE2, IF(CURREG_EXCHANGE2 > 0 ,

CURREG_EXCHANGE2 , CUR_EXCHANGE2))  As  DOLLAR_DUTYCOST,

(IV_DUTYCOST * (IF (DEBIT ='C',(-1),1)) * (IF(($(vEXPORTEXCHANGE)=1) AND IV_DUTYCOST <> 0,IV_IEXCHANGE,(IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3=INV_CURRENCY,FNC_EXCHANGE3,

if(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE )))))))/  IF(CURREG_EXCHANGE3 > 0 ,CURREG_EXCHANGE3 , CUR_EXCHANGE3) As  CURRENCY_DUTYCOST,

undergrinder
Specialist II
Specialist II

Hi Jhonatan,

It is hard to say anything, but I'm sure it will be just a syntax problem.

Missing comma, extra comma, missing brackets, extra brackets whatever, missing semicolon and so on.

If I have to write a complex expressions , I'll check it in Notepad++ to ensure all brackets have pairs and so on.

G.

sunny_talwar

How do you define vEXPORTEXCHANGE?