Discussion Board for collaboration related to QlikView App Development.
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..!!
See section "Generating all combinations of several fields" in http://community.qlik.com/docs/DOC-3786
But when I try those method the Security is not coming for the particular date.Because it dosen't have those values.
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.
Load Date, Security, Value,
Date & '|' & Security as RecordID
From ... ;
Load distinct Date Resident Data;
Load distinct Security Resident Data;
Load * Where Not Exists(RecordID);
Load Date, Security,
Null() as Value,
Drop Table TempData;
Thanks Henric its very helpful for me to sort out the problem..