topic Re: Garbage after statement in App Development

Garbage after statement

Tue, 08 Dec 2015 08:32:23 GMT

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

Re: Garbage after statement

Chanty4u — Tue, 08 Dec 2015 08:37:39 GMT

chk ur field names wit ur DB team..

Re: Garbage after statement

Tue, 08 Dec 2015 15:17:40 GMT

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,

Re: Garbage after statement

Tue, 08 Dec 2015 15:18:21 GMT

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,

Re: Garbage after statement

maxgro — Tue, 08 Dec 2015 15:38:46 GMT

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;

Re: Garbage after statement

manojkulkarni — Tue, 08 Dec 2015 15:43:27 GMT

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

Re: Garbage after statement

Tue, 08 Dec 2015 15:46:26 GMT

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

Re: Garbage after statement

maxgro — Tue, 08 Dec 2015 15:56:42 GMT

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

DROP Table Returns_tmp;

Re: Garbage after statement

Wed, 09 Dec 2015 08:10:19 GMT

mAX GRO THANK YOU VERY MUCH!

small qusetion: can i write in qliksense BETWEEN

that way i will see only specific months?

Re: Garbage after statement

Wed, 09 Dec 2015 08:12:23 GMT

i know that in qlikview that is no such option

Re: Garbage after statement

maxgro — Wed, 09 Dec 2015 18:35:45 GMT

It seems there isn't any between in Sense help

https://help.qlik.com/sense/2.1/en-US/online/#../Subsystems/ManagementConsole/Content/operators-and-functions-for-condit…