New to QV - Script Advice ....

[#1]

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'

[Gysbert_Wassenaar]

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.