topic Re: continously showing message 'Execution failed to reload' when reloading? in QlikView

continously showing message 'Execution failed to reload' when reloading?

Tue, 07 Jul 2015 11:06:44 GMT

Hi,

I have below script in qvw. when I reload every time it is showing 'Execution failed to reload'.

Data:

LOAD RowNo() as Row,

ID,

name,

address,

Date(dateofbirth,'DD/MM/YYYY') as dateofbirth,

Date([Enter Date],'DD/MM/YYYY') as [Enter Date],

IF(Len(PurgeChar(StageData1,'0123456789'))=0,Evaluate(StageData1),StageData1) as StageData1,

IF(Len(PurgeChar(StageData2,'0123456789'))=0,Evaluate(StageData2),StageData2) as StageData2,

Status,

Date([Status Date], 'DD/MM/YYYY') as [Status Date],

Passed,

Failed

FROM

QVD\Data.qvd]

(qvd);

Please can anyone suggest me is there any wrong in above script?

Thanks.

Re: continously showing message 'Execution failed to reload' when reloading?

Tue, 07 Jul 2015 11:23:30 GMT

Len(PurgeChar(StageData1,'0123456789'))=0,Evaluate(StageData1)

here when StageData1 is empty u r asking to evaluate

i tried evaluating empty field it gave "-"

so i hope loading such kind of data is creating problm but it must not throw any problem theoritically

Re: continously showing message 'Execution failed to reload' when reloading?

Tue, 07 Jul 2015 11:28:46 GMT

can u upload qvw?

Re: continously showing message 'Execution failed to reload' when reloading?

Tue, 07 Jul 2015 11:28:47 GMT

Thanks. when I comment RowNo() the script is executing fine. but only some values data is loading into the dateofbirth column and [Enter Date] columns. most of the data is missing in these two columns.

is there any way to set this problem?

Re: continously showing message 'Execution failed to reload' when reloading?

Tue, 07 Jul 2015 12:24:55 GMT

Please see attached. help me

Re: continously showing message 'Execution failed to reload' when reloading?

PrashantSangle — Tue, 07 Jul 2015 12:36:46 GMT

Hi,

Do you have document log of it???

Regards

Re: continously showing message 'Execution failed to reload' when reloading?

florentina_doga — Tue, 07 Jul 2015 12:57:17 GMT

use

IF(Len(PurgeChar(StageData1,'0123456789'))=0,text(StageData1),StageData1)