topic Re: Compare Date in QlikView

Compare Date

jyothish8807 — Tue, 15 Apr 2014 19:04:09 GMT

Hi All,

i have two table Master and table 2.

master table contains all the possible dates corresponding to a name.

Table 2 contain dates corresponding to same name, but the dates in this table may be different from the dates in master table.

Now i want to compare table 2 with master table and track all the dates which are not present in table 2 but present in master table,

Master:

Name Date

A Jan 2010

A Feb 2010

A Mar 2010

A Apr 2010

B Jan 2011

B Feb 2011

B Mar 2011

Table 2:

Name Date1

A Jan 2010

A Mar 2010

A Apr 2010

A May 2010

B Jan 2011

Now in table 2 for A Feb 2010 is missing, so i want to track that.and for B Feb 2011 and Mar 2011 is missing, so want to track that also.

Regards

Jyothish KC

Re: Compare Date

swuehl — Tue, 15 Apr 2014 19:32:27 GMT

Try like this:

Table2:

LOAD *, Name&Date1 as Key INLINE [

Name, Date1

A, Jan 2010

A, Mar 2010

A, Apr 2010

A, May 2010

B, Jan 2011

];

Master:

LOAD * INLINE [

Name, Date

A, Jan 2010

A, Feb 2010

A, Mar 2010

A, Apr 2010

B, Jan 2011

B, Feb 2011

B, Mar 2011

] where not exists (Key, Name&Date);

drop table Table2;

Re: Compare Date

Gysbert_Wassenaar — Tue, 15 Apr 2014 19:35:50 GMT

See attached qvw for another solution where you will still have the complete tables Master and Table 2.

Re: Compare Date

anbu1984 — Wed, 16 Apr 2014 05:42:58 GMT

In Sql

Select Name,Date from Master

Minus

Select Name,Date from Table2