Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

joins scenario please help

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

4 Replies
Highlighted

Re: joins scenario please help

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

HIC

Highlighted
Not applicable

Re: joins scenario please help

Thanks Henric,

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

Highlighted

Re: joins scenario please help

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

Highlighted
Not applicable

Re: joins scenario please help

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