topic Re: script error in QlikView

script error

Anonymous — Wed, 27 Jan 2016 16:46:10 GMT

Hi all,

I am doing loading and trying to generate QVD's based on some logic. But it is throwing error.

but site_visit_updated_datetime field is there.

Can anybody tell me what is reason.

Re: script error

swuehl — Wed, 27 Jan 2016 16:47:48 GMT

Seems you are using some variables that don't expand correctly.

They seem to be missing right from >= and <= operators.

Re: script error

Gysbert_Wassenaar — Wed, 27 Jan 2016 16:48:46 GMT

You're using variables that can't be resolved to a value. Make sure the variables you use actually have a value.

Re: script error

petter — Wed, 27 Jan 2016 16:49:32 GMT

If you show us the load script or the part that contains the LOAD statement together with the definition of the variable you are referring to in your WHERE clause - we could probably help out...

Re: script error

Colin-Albert — Wed, 27 Jan 2016 16:49:46 GMT

I would guess you are comparing the date to a variable and the variable is null.

Can you post your load statement?

Re: script error

HirisH_V7 — Wed, 27 Jan 2016 16:51:47 GMT

Hi,

Where Num(Site_Visit_Updated_time) >= and here ?

May be like this, Num(Site_Visit_Updated_time) >= (Recno()=20) ;

-Hirish

Re: script error

Anonymous — Wed, 27 Jan 2016 16:57:30 GMT

Hi All,

Thanks to all for ur quick replies.

Let Vqvdpath = 'D:\QlikView\SourceDocuments\QVX\Mktg_Funnel_Reports\Retention\QVD Retention\';

Max_Date:

LOAD Max(Floor(Timestamp#(site_visit_updated_datetime, 'DD/MM/YYYY hh:mm:ss.fff'))) as MaxMonth FROM

$(Vqvdpath)fact_site_visit.QVD (qvd) ;

LET vMaxMonth = num(AddMonths(Peek('MaxMonth'), -1));

LET vMinMonth = num(AddMonths(Peek('MaxMonth'), -13));

Drop Table Max_Date;

Visits13:

LOAD * FROM

$(Vqvdpath)fact_site_visit.QVD (qvd)

Where Num(site_visit_updated_datetime) >= $(vMaxMonth) and Num(site_visit_updated_datetime) <=$(vMinMonth);

If FileSize('$(Vqvdpath)fact_site_visit.qvd') > 0 then

Concatenate(Visits13)

LOAD *

FROM $(Vqvdpath)fact_site_visit.QVD(qvd)

Where Num(site_visit_updated_datetime) >= $(vMaxMonth) and Num(site_visit_updated_datetime) <=$(vMinMonth);

ENDIF

Store Visits13 into fact_site_visit.QVD (qvd);

Re: script error

Anonymous — Wed, 27 Jan 2016 17:00:47 GMT

I think,

It is because not exist condition, the order of the operators is incorrect, you used the same fields in twice cases.

Example:

Where Num(site_visit_updated_datetime) >= 10 and Num(site_visit_updated_datetime) <= 20

Regards.

Re: script error

swuehl — Wed, 27 Jan 2016 17:00:58 GMT

Have you checked the value of MaxMonth in the table and the created variables? What do these three values show?

Re: script error

Colin-Albert — Wed, 27 Jan 2016 17:11:25 GMT

Try adding quotes around your variables also check that the variables actually contain the correct data.

Where Num(site_visit_updated_datetime) >= '$(vMaxMonth)' and Num(site_visit_updated_datetime) <='$(vMinMonth)';

Re: script error

Anonymous — Wed, 27 Jan 2016 17:11:30 GMT

I am not getting u what you are trying to say.

My requirement to create QVD in between those months. According to you it will return10 months data?

Regards,

Kumar