topic Re: error handling in QlikView

error handling

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

hai,

i am having multiple files.some of the files has no data..while i am reloading,it showing error..

my requriement is,if the file has no data means it must be skip dt file n then reload the next file...which function is suit for my requiremnt and how????

thanks in advance.

if u not undrstnd means let me know.

Re: error handling

Anonymous — Fri, 13 Jan 2017 08:15:55 GMT

what's the error you are getting ?

Re: error handling

MK_QSL — Fri, 13 Jan 2017 08:43:48 GMT

Use FileSize() function while loading in the load script.

How can I check if a file exists ?

Possible to check file size before load?

Also check ErrorMode variable in load script

Re: error handling

Anonymous — Fri, 13 Jan 2017 09:17:43 GMT

error in exp ')' expectd.

Re: error handling

MK_QSL — Fri, 13 Jan 2017 09:19:29 GMT

What is the expression you have used?

Re: error handling

Anonymous — Fri, 13 Jan 2017 09:22:47 GMT

using if condition i have done.. if(((date=Date(Floor(MonthEnd(date))))or date=$(vMaxDate)),Qty,0) as zmonth_qty

Re: error handling

MK_QSL — Fri, 13 Jan 2017 09:25:47 GMT

Try this

If(date = Date(Floor(MonthEnd(date))) or date = $(vMaxDate), Qty, 0) as zmonth_qty

If(date = Date(Floor(MonthEnd(date))) or date = '$(vMaxDate)', Qty, 0) as zmonth_qty,

Re: error handling

Anonymous — Fri, 13 Jan 2017 09:31:32 GMT

hai manish..thanks for ur post..but it is not working..

Re: error handling

MK_QSL — Fri, 13 Jan 2017 09:34:18 GMT

Can you provide your whole script here?

Re: error handling

Anonymous — Fri, 13 Jan 2017 10:01:47 GMT

Hi Sindhu ja

if(date = Date(Floor(MonthEnd(date))) or date = '$(vMaxDate)',Qty,0) as zmonth_qty

The above expression should work suggested by Manish .

After working on manish's solution are you still getting the error?(I mean error in exp ')' expectd)

Then check whether you are getting correct date values for vMaxDate.

Re: error handling

Anonymous — Fri, 13 Jan 2017 10:04:36 GMT

actually i told..some of d file has no data..so nly there is occured..thts y i need solution for dt.

Re: error handling

Anonymous — Fri, 13 Jan 2017 10:28:15 GMT

share the app