Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

error handling

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.

11 Replies
Anonymous
Not applicable
Author

what's the error you are getting ?

MK_QSL
MVP
MVP

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


Anonymous
Not applicable
Author

error in exp ')' expectd.

MK_QSL
MVP
MVP

What is the expression you have used?

Anonymous
Not applicable
Author

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

MK_QSL
MVP
MVP

Try this

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

or

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

Anonymous
Not applicable
Author

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

MK_QSL
MVP
MVP

Can you provide your whole script here?

Anonymous
Not applicable
Author

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.