New to QV - Script Advice ....

Tue, 21 May 2013 14:28:55 GMT

Hi Im new to Qlikview and have 'inherited' a qlikview dashboard froma previous employee.

One of the main data loading scripts is this :

Main_Load:
Load
date(monthstart(date1), 'MMM-YY') as MonthYear,*;
LOAD *
FROM
c:\qlikview_main.qvd
(qvd);

[Indicator]:
Left Join (Main_Load)

LOAD * FROM
c:\qlikView_indicator.qvd
(qvd);

Main2:
noconcatenate Load * Resident Main_Load WHERE inc_A='Y' or inc_B='Y';

Drop table Main_Load;

store Main2 into c:\performance.qvd;

My query is what the 'Main2' load is doing. There are values which seem to be missing from 'performance.qvd' even though they have inc_A and inc_B set to 'Y'.

Can someone explain what the 'noconcatenate' statement is doing?

Many thanks

'The ADF 38s'

Re: New to QV - Script Advice ....

Gysbert_Wassenaar — Tue, 21 May 2013 16:30:32 GMT

The 'missing' records are likely caused by the left join. Any records in qlikView_indicator.qvd that don't have matching records in qlikview_main.qvd are dropped.

The noconcatenate prevents the data being added to Main_Load. The Main2 load statement loads the same field names as are in Main_Load. In that case Qlikview will automatically add the records to Main_Load unless noconcatenate is specified. It stores Main2 into a separate table. That makes it possible to drop Main_Load so only the filtered data in Main2 results.

topic Re: New to QV - Script Advice .... in QlikView

New to QV - Script Advice ....

Re: New to QV - Script Advice ....