Creating dummy records for missing data in a table

[danaleota1]

I have the following table:

[SLATable]:

Load
Date,
INSTITUTIONAME,
INTSANS,
SL1,
SLA

FROM [lib://myqvd.qvd]
(qvd)

There are some INSTITUTIONNAME & Date combinations that won't always populate records for a given day Ion these dates I would still like records and have the SL1 field and INTSANS field to populate zeros so I have dummy records in order to populate a pivot table with accumulative sums.  How would I create dummy records in this case?  Thank you.  

[Chanty4u]

Have a look on below thread.

https://community.qlik.com/t5/QlikView-App-Development/populate-missing-values/td-p/14297

https://community.qlik.com/t5/QlikView-App-Development/Auto-fill-the-missing-value/td-p/475576

[kaushiknsolanki · Accepted solution]

Hi,

You should use the Cartesian product to generate the missing values. Like below.

Temp:
Load Distinct INSTITUTIONAME
FROM [lib://myqvd.qvd]
(qvd);

Join (Temp)

Load Distinct Date
FROM [lib://myqvd.qvd]
(qvd);

MainTable:
Load INSTITUTIONAME & '-'& Date as Key,
INSTITUTIONAME ,
Date
Resident Temp;

Drop table Temp;

Left join(MainTable)
Load *,INSTITUTIONAME & '-'& Date as Key
FROM [lib://myqvd.qvd]
(qvd);

[danaleota1]

Hi Kaushik that worked.  My pivot table now has an accumulative count where there had been no records before.  

Thank you!