topic Re: error when reloading in QlikView

error when reloading

Fri, 18 Jul 2014 14:47:18 GMT

I am getting a script line error when reloading my qvd file. the error message is in the image attached

Re: error when reloading

MK_QSL — Fri, 18 Jul 2014 14:55:17 GMT

Looks like error in your Variable Creation...

can you post your variable definition...?

Re: error when reloading

Fri, 18 Jul 2014 14:57:29 GMT

Re: error when reloading

Fri, 18 Jul 2014 15:00:16 GMT

where do I find this?

Re: error when reloading

simenkg — Fri, 18 Jul 2014 15:01:16 GMT

your WeekEND() and WeekStart() are empty. They Take arguments.

This looks like you are using a variable wrong. if you are using WeekEnd(vVariable) try WeekEnd($(vVariable)). If this still gives the same error try WeekEnd('$(vVariable)')

Hope this helps

Regards
SKG

Re: error when reloading

Fri, 18 Jul 2014 15:11:22 GMT

So I go into settings then variable overview, find vMaxWeek then what?

Re: error when reloading

simenkg — Fri, 18 Jul 2014 15:14:09 GMT

No, this is an error in the script.

You open your script editor (CTRL + E) and change it where it is defined in the script.

find the line that starts with

let vMaxWeek = ...

And change what stands between the () in WeekEnd and WeekStart

Re: error when reloading

martynlloyd — Fri, 18 Jul 2014 15:19:12 GMT

Please post the whole line here so we can edit for you.

Regards.

Re: error when reloading

Fri, 18 Jul 2014 15:20:53 GMT

Re: error when reloading

Fri, 18 Jul 2014 15:36:35 GMT

Ok so I looked everywhere in the edit script but it is not there. A consultant made this for us but it looks like he included script from another file (picture below) but even when I hide the script nothing changes

Re: error when reloading

martynlloyd — Fri, 18 Jul 2014 15:38:23 GMT

As SKG mentioned, you do not have a date in your weekend functions.

Re: error when reloading

simenkg — Fri, 18 Jul 2014 15:38:59 GMT

Look under the tab called Census Calendar.

It would be the logical place for it.

Re: error when reloading

Fri, 18 Jul 2014 15:43:22 GMT

nvm that last post

I found it here

Re: error when reloading

simenkg — Fri, 18 Jul 2014 15:48:09 GMT

Try changing $(vMaxDate) to '$(vMaxDate)' and post the new error message if it crashes again.

if this does not fix the issue, then the line
Let vMaxDate = Num(Peek('MaxDate',0,'MinMax'));
returns an empty value. If that is the case we need to see where the MinMax-table is defined.

Re: error when reloading

Anonymous — Fri, 18 Jul 2014 15:49:57 GMT

What Simen is saying that makes sense. You try to change your definition something like below

In your case, it seems vMaxdate is not able to compute data and it becomes empty, so weekend() is throwing error. PLease check separately, if there is indeed any data returned from vMaxDate from log file.

Re: error when reloading

Fri, 18 Jul 2014 15:52:41 GMT

It looks like that ran but I am getting another error.

Re: error when reloading

simenkg — Fri, 18 Jul 2014 15:54:40 GMT

This is the same error. Simply change $(vMaxDate) to '$(vMaxDate)' in the whole sheet and see if that fixes it.

Re: error when reloading

Fri, 18 Jul 2014 16:06:48 GMT

next error

Re: error when reloading

simenkg — Fri, 18 Jul 2014 16:09:32 GMT

Did you do the same for the vMinDate variable?

eg. change $(vMinDate) to '$(vMinDate)'

Re: error when reloading

Fri, 18 Jul 2014 16:18:41 GMT

Simen, I appreciate all your help thank you very much. But I am having trouble fixing this script below. I dont know where the correct place for brackets are.