topic Re: script error in QlikView

script error

master_student — Fri, 21 Jul 2017 08:28:09 GMT

hello Guys,

I got this error :

here is my script : Erreur de ligne de script

let vDWDate = date(today()-5,'YYYY-MM-DD');

let vToday = date(today(),'YYYY-MM-DD');

for iDaysBack = 0 to (vToday - vDWDate)

let vNextDay = Date(vToday - iDaysBack, 'YYYY-MM-DD');

test:

load *

;

sql query

NoConcatenate

MontantRecouvrementBillCycle:

load *,

AutoNumber(MakeDate( Year(date_id), Month(date_id), Day(date_id)), '%Date ID') as [%Date ID]

resident test;

drop table test;

let vDWDate1 = date(today()-5,'YYYY-MM-DD');

let vToday1 = date(today(),'YYYY-MM-DD');

for iDaysBack1 = 0 to (vToday1 - vDWDate1)

let vNextDay1 = Date(vToday1 - iDaysBack1, 'YYYY-MM-DD');

test1:

load *

;

sql query

NoConcatenate

requete2:

load *,

AutoNumber(MakeDate( Year(date_id), Month(date_id), Day(date_id)), '%Date ID') as [%Date ID]

resident test1;

drop table test1;

exit script ;

Re: script error

Anil_Babu_Samineni — Fri, 21 Jul 2017 08:37:07 GMT

Script line Error, Can you please show error in image? Which line and please high light the line

Re: script error

master_student — Fri, 21 Jul 2017 09:13:51 GMT

Re: script error

prma7799 — Fri, 21 Jul 2017 09:18:26 GMT

Please remove this "sql query" and try or comment that word .

write proper statement in here

test:

load *

;

Re: script error

master_student — Fri, 21 Jul 2017 09:21:04 GMT

by sql query i mean : select * from xxx ....

Re: script error

prma7799 — Fri, 21 Jul 2017 09:26:51 GMT

Please try to debug script one by one then you will get exact issue ...

Re: script error

jonathandienst — Fri, 21 Jul 2017 09:28:21 GMT

The sql statement has no semicolon to terminate it:

for iDaysBack = 0 to (vToday - vDWDate)

let vNextDay = Date(vToday - iDaysBack, 'YYYY-MM-DD');

test:

load *

;

sql query

next

Re: script error

master_student — Fri, 21 Jul 2017 10:38:50 GMT

the pb is with the next statment whene i comment it the sql query works but brings data of today only...

Re: script error

master_student — Fri, 21 Jul 2017 10:41:59 GMT

I didn't get your message what i am supposed to do?

Thanks

Re: script error

master_student — Fri, 21 Jul 2017 10:52:41 GMT

Any help please ??

Thanks

Re: script error

prma7799 — Fri, 21 Jul 2017 10:57:28 GMT

Please share your script..

Re: script error

master_student — Fri, 21 Jul 2017 11:08:43 GMT

ODBC CONNECT TO SYS_PROD;

let vDWDate1 = date(today()-5,'DD/MM/YYYY');

let vToday1 = date(today()-2,'DD/MM/YYYY');

for iDaysBack1 = 0 to (vToday1 - vDWDate1)

let vNextDay1 = Date(vToday1 - iDaysBack1, 'DD/MM/YYYY');

test1:

load *

;

select ....

where date_id =to_date('$(vNextDay1)' ,'DD/MM/YYYY')

and ...

group by 1,2,3 ,4) a

full outer join

(select

where date_id = date_trunc('month', to_date('$(vNextDay1)' ,'DD/MM/YYYY') )

and ......

next ;

NoConcatenate

requete2:

load *,

AutoNumber(MakeDate( Year(date_id), Month(date_id), Day(date_id)), '%Date ID') as [%Date ID]

resident test1;

drop table test1;

exit script ;

Re: script error

prma7799 — Fri, 21 Jul 2017 11:26:56 GMT

Please terminate your sql statement with ; and try

select ....

where date_id =to_date('$(vNextDay1)' ,'DD/MM/YYYY')

and ...

group by 1,2,3 ,4) a

full outer join

(select

where date_id = date_trunc('month', to_date('$(vNextDay1)' ,'DD/MM/YYYY') )

and ......

;

Re: script error

master_student — Fri, 21 Jul 2017 12:22:32 GMT

I already terminate it with ;

Re: script error

prma7799 — Fri, 21 Jul 2017 12:33:03 GMT

Could you please share your application ?

Re: script error

Anil_Babu_Samineni — Fri, 21 Jul 2017 13:44:06 GMT

Can you do this for me a while

SET ErrorMode = 0;

//SET ErrorMode = 0;

>>>>>>>>>>>> Script Here <<<<<<<<<<<<<

Trace 'Error Here' & Chr(10) & '$(ErrorMode)';

Re: script error

master_student — Thu, 27 Jul 2017 12:40:50 GMT

Thanks Anil. it works but what was the pb?

Re: script error

Anil_Babu_Samineni — Tue, 01 Aug 2017 09:09:43 GMT

Look here ErrorMode ‒ QlikView