Where Exists condition

[qlikview979]

Hi Experts,

How can i write Where Exists condition in qlikview by using "AND" can any one give with Example ?

Regards,

Mahesh

[Anonymous]

try

load

a,b,c

resident Test

where exists(a) and (b='1')

load all data where datarow with a laready loaded and b contains value 1

[qlikview979]

Hi Bro,

Here Data like this

T1:

DATE

Jan

Feb

Mar

T2:

DATE1

Jan

Feb

Mar

Apr

Jul

Here i want matching months dynamically

Regards,

Mahesh

[santiago_respane]

Hi,

you can try like this:

T1:

LOAD DATE FROM [mySource1];

T2:

Load DATE1 FROM [mySource2] WERE EXISTS(DATE,DATE1 );

Hope this helps.

Kind regards,

[Anonymous]

T1:
load * inline [
DATE
Jan
Feb
Mar
];

  T2:
load * Inline [
DATE1
Jan
Feb
Mar
Apr
Jul
];

Test:
NoConcatenate
load DATE1
Resident T2
where Exists(DATE,DATE1)

gets you this result (is it what you want?)

[qlikview979]

Hi All,

I have Date field i changed to month  i done  how you guys said but i am not getting

Regards,

Mahesh

[Anonymous]

cyn aou post sampe qvw?

are the monthfield in two tables are same Format?

[qlikview979]

While reloading time also Where condition table lines showing fetching zero lines

[qlikview979]

if i remove the where condition lines fetching started

[sunny_talwar]

Do you have month fields as the same thing? I mean may be one month is dual field created using Month() function and the other one is text created inline may be?