Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikview979
Specialist
Specialist

Where Exists condition

Hi Experts,

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

Regards,

Mahesh

14 Replies
Anonymous
Not applicable

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
Specialist
Specialist
Author

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
Specialist
Specialist

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
Not applicable

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
Specialist
Specialist
Author

Hi All,

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

Regards,

Mahesh

Anonymous
Not applicable

cyn aou post sampe qvw?

are the monthfield in two tables are same Format?

qlikview979
Specialist
Specialist
Author

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

qlikview979
Specialist
Specialist
Author

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?