topic Re: Differing behaviour in script and front end in QlikView

Differing behaviour in script and front end

Fri, 04 Mar 2016 10:17:23 GMT

I am sure there is a valid explanation why this is happening but as I can't figure it out I am turning to the experts.

I have a table which loads UK bank holidays from the web and then concatenates/comma separates them. I then move them into a variable as follows:

LET PublicHolidayList = peek('PublicHolidayList');

This is the result:

'01/01/2015', '01/01/2016', '01/05/2017', '02/01/2017', '02/05/2016', '03/04/2015', '04/05/2015', '06/04/2015', '14/04/2017', '17/04/2017', '25/03/2016', '25/05/2015', '25/12/2015', '25/12/2017', '26/12/2016', '26/12/2017', '27/12/2016', '28/03/2016', '28/08/2017', '28/12/2015', '29/05/2017', '29/08/2016', '30/05/2016', '31/08/2015'

In my calendar load I am using this statement:

networkdays(monthstart(Date,0),Date,$(#PublicHolidayList))

If I use the exact same statement in a chart I get different (correct) results.

For January 2016

Date	NetWorkDays (script)	NetWorkDays (table expr)
01/01/2016	1	0
02/01/2016	1	0
03/01/2016	1	0
04/01/2016	2	1
05/01/2016	3	2
06/01/2016	4	3

etc...

It looks like the script is not 'seeing' a valid date in the last argument of networkdays and assigning it a work day.

What am I missing?

Thanks

Oli

Re: Differing behaviour in script and front end

Anonymous — Fri, 04 Mar 2016 10:31:17 GMT

Why have you got the # ?

networkdays(monthstart(Date,0),Date,$(#PublicHolidayList))

Re: Differing behaviour in script and front end

Anonymous — Fri, 04 Mar 2016 10:33:38 GMT

Also if in your Straight Table you remove the label from an expression and then hover over where the label it should show you the expression with the dollar expansion expanded which makes diagnostics easier.

Re: Differing behaviour in script and front end

Fri, 04 Mar 2016 10:37:40 GMT

Because it's been a long week and I am an idiot! A simple typo but I couldn't see the wood for the tree

Thank you Bill

Re: Differing behaviour in script and front end

Anonymous — Fri, 04 Mar 2016 10:47:01 GMT

Is it working for you now ?

I often go snow blind as well after staring at screen for too long and can no longer see the BLOB, as in the BLindingly OBvious.

Re: Differing behaviour in script and front end

Mon, 07 Mar 2016 08:58:46 GMT

All good now thank Bill