topic Re: Not Exist issue in QlikView

Not Exist issue

brijesh1991 — Thu, 09 Jan 2014 12:33:44 GMT

Hi All,

I have two two tables. First table contains 30 IDs, second Table contains 100 IDs. I don't want those 30 IDs in my Dashboard.

So I use Not Exist function. Will you suggest is there any wrong with it?

My script demo:

Table1:

Load ID from Table1;

Table2:

Load ID from Table2 where not exist(ID);

drop table Table1;

Re: Not Exist issue

luciancotea — Thu, 09 Jan 2014 12:39:05 GMT

Table1:

Load ID as ID_BAD from Table1;

Table2:

Load ID from Table2 where not exist(ID_BAD, ID);

drop table Table1;

Re: Not Exist issue

brijesh1991 — Thu, 09 Jan 2014 13:00:19 GMT

Hi Cotea,

Thanks. . . Not exists not working.. It's giving me 100 IDs only.

Re: Not Exist issue

luciancotea — Thu, 09 Jan 2014 13:24:08 GMT

This works:

Table1:

LOAD * INLINE [

    ID_BAD

    1

    2

    3

];

Table2:

LOAD * INLINE [

    ID

    1

    2

    3

    4

    5

    6

    7

    8

    9

    10

]

where not exists(ID_BAD, ID);

drop table Table1;

The result will be the numbers from 4 to 10.

Re: Not Exist issue

sujeetsingh — Thu, 09 Jan 2014 13:27:22 GMT

can also write as

where ID<>null()

Re: Not Exist issue

brijesh1991 — Fri, 10 Jan 2014 04:42:24 GMT

Thanks Lucian Kotea... It worked....

When I was taking tables directly, it wasn't working.... then I take resident of the same and both tables need to force 'noconcate', then it's working fine...

Your answer is absolutely correct!

Thanks Brother!