topic Re: null values in QlikView

null values

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

Hai,

i got a error in expression ')' expected even the scripts are correct.but the file has no data..so i am thinking,it could be bttr,if i insert null values in dt file.is thz possible..r does anyone knows any good idea.i have tried many things to rectify this pblm..

but no results..thanks in advance.

Re: null values

avinashelite — Wed, 11 Jan 2017 05:39:38 GMT

Information is not clear , explain with an example and share the script and expressions

Re: null values

Anonymous — Wed, 11 Jan 2017 05:47:52 GMT

load

Date,Qty

from(blah blah)

LOAD

Max(Date) as MaxDate

Resident A;

LET vMaxDate = floor(peek('MaxDate'));

DROP Table B;

A1:

LOAD *,

if(((Date=Date(Floor(MonthEnd(Date))))or Date=$(vMaxDate)),Qty,0) as month_qty

Resident A;

DROP Table A;

the error is in variable.y bcoz that file has no data.what can i do to find the solution.and i am using same format of expression to all.bt this file nly showing error.due to no data..i think so.

Re: null values

jonathandienst — Wed, 11 Jan 2017 06:03:56 GMT

If you want to pass over some of the script if the file is empty, then perhaps something like this:

LOAD

Date,

Qty

from(blah blah);

If Alt(NoOfRows('A'), 0) > 0 Then

LOAD

Max(Date) as MaxDate

Resident A;

LET vMaxDate = Floor(Peek('MaxDate'));

DROP Table B;

A1:

LOAD *,

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

Resident A;

DROP Table A;

Else

TRACE --> No data to load;

End If

Re: null values

Anonymous — Wed, 11 Jan 2017 06:30:29 GMT

Hai..ur post must be helpful to me..thanks a lot.

Re: null values

Anonymous — Wed, 11 Jan 2017 06:35:39 GMT

hai,

jonathan...i am not sure but wht abt the error mode function.. this function also help to this ???????can u explain me.