topic Re: Load Script Getting error. in QlikView

Load Script Getting error.

palanimurugan — Wed, 25 Nov 2020 16:16:04 GMT

Dear Experts,

Please help me to fix this problem. below load script is showing error while loading the script.

tab1:

Load

Floor((Date('2018-05-05','YYYY-MM-DD') - (date(min(Rreviewdate),'YYYY-MM-DD')))/30.5)

resident existing table Group By id;

Re: Load Script Getting error.

sunny_talwar — Sun, 08 Apr 2018 18:20:14 GMT

Not sure, but is the field called Rreviewdate or Reviewdate? may be just a typo?

Re: Load Script Getting error.

pradosh_thakur — Sun, 08 Apr 2018 18:44:29 GMT

tab1:

Load

id,

Floor((Date('2018-05-05','YYYY-MM-DD') - (date(min(Rreviewdate),'YYYY-MM-DD')))/30.5)

resident existing table Group By id;

Missed a comma after id ??

Re: Load Script Getting error.

sasiparupudi1 — Sun, 08 Apr 2018 18:50:07 GMT

may be

tab1:

Load

id,

(Date#('2018-05-05','YYYY-MM-DD') -Floor(min(Rreviewdate)))/30.5

resident existing table Group By id;

Re: Load Script Getting error.

palanimurugan — Mon, 09 Apr 2018 04:27:55 GMT

Hi..

It is a date field (Rreviewdate is correct), have to take minimum date. If I remove the min function, Loading correctly.

Re: Load Script Getting error.

prma7799 — Mon, 09 Apr 2018 04:38:02 GMT

Try this

tab1:

Load

id,

((Date('2018-05-05','YYYY-MM-DD') - (date(min(Rreviewdate),'YYYY-MM-DD')))/30.5)

resident existing table Group By id;

or please share your error

Re: Load Script Getting error.

palanimurugan — Mon, 09 Apr 2018 06:26:41 GMT

Hi.

it is my typo sorry !!!

Re: Load Script Getting error.

shiveshsingh — Mon, 09 Apr 2018 07:56:20 GMT

I think, you should use group by with Aggregation function.

Re: Load Script Getting error.

ramasaisaksoft — Mon, 09 Apr 2018 08:56:26 GMT

Hi Muruga,

as per my understanding we need to give like below in your script editor.

tab1:

Load

id,

Floor((Date('2018-05-05','YYYY-MM-DD') - (date(min(Rreviewdate),'YYYY-MM-DD')))/30.5) As date_diff

resident tab1 Group By id;

If i understood your query please correct me by your Error screen shot

if it is not solved your issue , please copy & paste your script and screenshot of your error so that our folks will more help to you ASAP.

Re: Load Script Getting error.

palanimurugan — Mon, 09 Apr 2018 09:29:29 GMT

Dear Experts,

Thank you for your valuable comments. As per your comments finally I resolved my end.

Now it is working fine.

Re: Load Script Getting error.

palanimurugan — Mon, 09 Apr 2018 09:32:08 GMT

Hi Rama Sai,

Thank you for the reply.. finally the script is working!!

Re: Load Script Getting error.

olivierrobin — Mon, 09 Apr 2018 09:43:56 GMT

hello

could you a copy of the error message

and the load instruction

Re: Load Script Getting error.

sasiparupudi1 — Mon, 09 Apr 2018 18:07:33 GMT

‌pplease close the thread by marking a correct answer

Re: Load Script Getting error.

palanimurugan — Fri, 13 Apr 2018 12:33:19 GMT

Okay sure.. Sasi..