topic joins scenario please help in QlikView

joins scenario please help

Thu, 05 Sep 2013 13:22:12 GMT

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..!!

Re: joins scenario please help

hic — Thu, 05 Sep 2013 13:25:46 GMT

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

HIC

Re: joins scenario please help

Thu, 05 Sep 2013 13:54:01 GMT

Thanks Henric,

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

Re: joins scenario please help

hic — Thu, 05 Sep 2013 14:04:02 GMT

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

Re: joins scenario please help

Thu, 12 Sep 2013 07:43:50 GMT

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