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

Garbage after statement

Hey everyone  i am getting the following error:

i tried to find the reason but could not find the problem

Garbage after statement: Returns: Load TRANS_TYPE, TRANS_CURDATE, (if(TRANS_TYPE='X',TRANS_IVCUST,TRANS_CUST))AS TRANS_CUST, TRANS_BRANCH, TRANS_DOCNO, TRANS_IVNUM, (if(TRANS_TYPE='X',TRANS_IVAGENT,TRANS_DOCAGENT)) AS TRANS_AGENT, TRANS_PART, TRANS_IVCOST, TRANS_IVIEXCHANGE, TRANS_IVPRICE , TRANS_TQUANT, TRANS_IVTQUANT, IF(TRANS_TYPE= 'X',NIS_TRANS_IVPRICE, (TRANS_PRICE * TRANS_TQUANT) * (100 - TRANS_PERCENT)/100 * (IF (TRANS_TYPE='N',(-1),1)) * TRANS_IEXCHANGE * (100 - TRANS_DOCPERCENT)/100) AS NIS_TRANS_TOTPRICE, IF(TRANS_TYPE= 'X',NIS_TRANS_IVPRICE, (TRANS_PRICE * TRANS_TQUANT) * (100 - TRANS_PERCENT)/100 * (IF (TRANS_TYPE='N',(-1),1)) * TRANS_IEXCHANGE * (100 - TRANS_DOCPERCENT)/100) / (IF(CURREG_EXCHANGE2 > 0 ,CURREG_EXCHANGE2 , CUR_EXCHANGE2) ) AS DOLLAR_TRANS_TOTPRICE, IF(TRANS_TYPE= 'X',NIS_TRANS_IVPRICE, (TRANS_PRICE * TRANS_TQUANT) * (100 - TRANS_PERCENT)/100 * (IF (TRANS_TYPE='N',(-1),1)) * TRANS_IEXCHANGE * (100 - TRANS_DOCPERCENT)/100) / (IF(CURREG_EXCHANGE3 > 0 ,CURREG_EXCHANGE3 , CUR_EXCHANGE3) ) AS CURRENCY_TRANS_TOTPRICE, (if(TRANS_TYPE='X',TRANS_IVCUST,TRANS_CUST))& '_' & (if(TRANS_TYPE='X',TRANS_IVAGENT,TRANS_DOCAGENT))& '_' & TRANS_BRANCH&'_' & TRANS_PART & '_'& TRANS_CURDATE AS SALES_KEY Resident Returns_tmp Where TRANS_CURDATE >= '01/01/2010' DROP Table Returns_tmp

1 Solution

Accepted Solutions
maxgro
MVP
MVP

Where TRANS_CURDATE >= '01/01/2010';

DROP Table Returns_tmp;

View solution in original post

10 Replies
Chanty4u
MVP
MVP

chk ur field names wit ur DB team..

Not applicable
Author

o.k i tried using the d - bugging and got this:

IF(TRANS_TYPE= 'X',NIS_TRANS_IVPRICE,

(TRANS_PRICE * TRANS_TQUANT) * (100 - TRANS_PERCENT)/100 *  (IF (TRANS_TYPE='N',(-1),1)) *

TRANS_IEXCHANGE * (100 - TRANS_DOCPERCENT)/100)

AS NIS_TRANS_TOTPRICE,

// // //מחיר בדולרים משורת תעודה     

IF(TRANS_TYPE= 'X',NIS_TRANS_IVPRICE,

(TRANS_PRICE * TRANS_TQUANT) * (100 - TRANS_PERCENT)/100 *  (IF (TRANS_TYPE='N',(-1),1)) *

TRANS_IEXCHANGE * (100 - TRANS_DOCPERCENT)/100)

// /

(IF(CURREG_EXCHANGE2  > 0 ,CURREG_EXCHANGE2 , CUR_EXCHANGE2) )

AS DOLLAR_TRANS_TOTPRICE,

// //מחיר במטבע שלישי משורת התעודה

IF(TRANS_TYPE= 'X',NIS_TRANS_IVPRICE,

(TRANS_PRICE * TRANS_TQUANT) * (100 - TRANS_PERCENT)/100 *  (IF (TRANS_TYPE='N',(-1),1)) *

TRANS_IEXCHANGE * (100 - TRANS_DOCPERCENT)/100)

/

(IF(CURREG_EXCHANGE3  > 0 ,CURREG_EXCHANGE3 , CUR_EXCHANGE3) )

AS CURRENCY_TRANS_TOTPRICE,

Not applicable
Author

i meant that i  see the problems are here:

IF(TRANS_TYPE= 'X',NIS_TRANS_IVPRICE,

(TRANS_PRICE * TRANS_TQUANT) * (100 - TRANS_PERCENT)/100 *  (IF (TRANS_TYPE='N',(-1),1)) *

TRANS_IEXCHANGE * (100 - TRANS_DOCPERCENT)/100)

AS NIS_TRANS_TOTPRICE,

// // //מחיר בדולרים משורת תעודה     

IF(TRANS_TYPE= 'X',NIS_TRANS_IVPRICE,

(TRANS_PRICE * TRANS_TQUANT) * (100 - TRANS_PERCENT)/100 *  (IF (TRANS_TYPE='N',(-1),1)) *

TRANS_IEXCHANGE * (100 - TRANS_DOCPERCENT)/100)

// /

(IF(CURREG_EXCHANGE2  > 0 ,CURREG_EXCHANGE2 , CUR_EXCHANGE2) )

AS DOLLAR_TRANS_TOTPRICE,

// //מחיר במטבע שלישי משורת התעודה

IF(TRANS_TYPE= 'X',NIS_TRANS_IVPRICE,

(TRANS_PRICE * TRANS_TQUANT) * (100 - TRANS_PERCENT)/100 *  (IF (TRANS_TYPE='N',(-1),1)) *

TRANS_IEXCHANGE * (100 - TRANS_DOCPERCENT)/100)

/

(IF(CURREG_EXCHANGE3  > 0 ,CURREG_EXCHANGE3 , CUR_EXCHANGE3) )

AS CURRENCY_TRANS_TOTPRICE,

maxgro
MVP
MVP

this works without error

Load TRANS_TYPE, TRANS_CURDATE,

(if(TRANS_TYPE='X',TRANS_IVCUST,TRANS_CUST)) AS TRANS_CUST,

TRANS_BRANCH, TRANS_DOCNO, TRANS_IVNUM,

(if(TRANS_TYPE='X',TRANS_IVAGENT,TRANS_DOCAGENT)) AS TRANS_AGENT,

TRANS_PART, TRANS_IVCOST, TRANS_IVIEXCHANGE, TRANS_IVPRICE , TRANS_TQUANT, TRANS_IVTQUANT,

IF(TRANS_TYPE= 'X',NIS_TRANS_IVPRICE, (TRANS_PRICE * TRANS_TQUANT) * (100 - TRANS_PERCENT)/100 *

  (IF (TRANS_TYPE='N',(-1),1)) * TRANS_IEXCHANGE * (100 - TRANS_DOCPERCENT)/100) AS NIS_TRANS_TOTPRICE,

IF(TRANS_TYPE= 'X',NIS_TRANS_IVPRICE, (TRANS_PRICE * TRANS_TQUANT) * (100 - TRANS_PERCENT)/100 *

  (IF (TRANS_TYPE='N',(-1),1)) * TRANS_IEXCHANGE * (100 - TRANS_DOCPERCENT)/100)

  / (IF(CURREG_EXCHANGE2 > 0 ,CURREG_EXCHANGE2 , CUR_EXCHANGE2) ) AS DOLLAR_TRANS_TOTPRICE,

IF(TRANS_TYPE= 'X',NIS_TRANS_IVPRICE, (TRANS_PRICE * TRANS_TQUANT) * (100 - TRANS_PERCENT)/100 *

  (IF (TRANS_TYPE='N',(-1),1)) * TRANS_IEXCHANGE * (100 - TRANS_DOCPERCENT)/100)

  / (IF(CURREG_EXCHANGE3 > 0 ,CURREG_EXCHANGE3 , CUR_EXCHANGE3) ) AS CURRENCY_TRANS_TOTPRICE,

(if(TRANS_TYPE='X',TRANS_IVCUST,TRANS_CUST))& '_' & (if(TRANS_TYPE='X',TRANS_IVAGENT,TRANS_DOCAGENT))& '_'

  & TRANS_BRANCH&'_' & TRANS_PART & '_'& TRANS_CURDATE AS SALES_KEY

Resident Returns_tmp Where TRANS_CURDATE >= '01/01/2010' ;

DROP Table Returns_tmp;

manojkulkarni
Partner - Specialist II
Partner - Specialist II

i think semicolon is missing in last line before drop table statement.

Not applicable
Author

wow! that is it!! what was the problem?

maxgro
MVP
MVP

Where TRANS_CURDATE >= '01/01/2010';

DROP Table Returns_tmp;

Not applicable
Author

mAX GRO THANK YOU VERY MUCH!

small qusetion:  can i write in qliksense BETWEEN

that way i will see only specific months?

Not applicable
Author

i know that in qlikview that is no such option