joins scenario please help

[#1]

Hi I have an table which looks like..

For 2/6/2012 and 2/7/2012 there is no security C but I want datas those dates with null value

There is no datas in the data base how I get the data anyone please help

Thanks in advance..!!

[hic]

See section "Generating all combinations of several fields" in http://community.qlik.com/docs/DOC-3786

HIC

[#3]

Thanks Henric,

But when I try those method the Security is not coming for the particular date.Because it dosen't have those values.

[hic]

You can do it according to the script below. The "TempData" table will contain all combinations of Date and Security, and when you load from this, you filter on RecordID so that you only get the ones you don't have yet.

Data:

Load Date, Security, Value,

   Date & '|' & Security as RecordID

   From ... ;

TempData:

Load distinct Date Resident Data;

Join

Load distinct Security Resident Data;

Concatenate (Data)

Load * Where Not Exists(RecordID);

Load Date, Security,

   Null() as Value,

   Date & '|' & Security as RecordID

   Resident TempData;

Drop Table TempData;

HIC

[#5]

Thanks Henric its very helpful for me to sort out the problem..