Load script only creates one table

Wed, 19 Aug 2015 16:20:18 GMT

I have a load script like this:

LOAD

if(Round(date((date([Pep due date], 'DD/MM/YYYY') - date(Now(), 'DD/MM/YYYY')),'DD')) > 30, 'G',

if(Round(date((date([Pep due date], 'DD/MM/YYYY') - date(Now(), 'DD/MM/YYYY')),'DD')) <= 29 and Round(date((date([Pep due date], 'DD/MM/YYYY') - date(Now(), 'DD/MM/YYYY')),'DD')) > 0, 'A',

if(Round(date((date([Pep due date], 'DD/MM/YYYY') - date(Now(), 'DD/MM/YYYY')),'DD')) <= 0, 'R'))) AS Group;

SQL SELECT

c.duedate AS 'Pep due date'

FROM LacTest.dbo.table a

join lactest.dbo.include b on a.upn = b.upn

left join lactest.dbo.pep c on a.upn = c.upn

where b.active = 1;

The first part of the script is supposed to sort the data into one of three groups so that I can do a RAG pie chart. The second part loads data from an SQL table.

But when I run this script only the Group table is create in qv - no data from SQL at all!

Please can someone explain why?

Re: Load script only creates one table

Nicole-Smith — Wed, 19 Aug 2015 16:24:43 GMT

It's called a preceding load.

Detailed information can be found here: Preceding Load

Re: Load script only creates one table

Wed, 19 Aug 2015 22:24:38 GMT

‌hi mark,

if you need the columns from the sale as well, then all you need to do is add a "*" after "load".

LOAD

, if(Round(date...

topic Re: Load script only creates one table in QlikView

Load script only creates one table

Re: Load script only creates one table

Re: Load script only creates one table