topic Where Exists condition in QlikView

Where Exists condition

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

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

Regards,

Mahesh

Re: Where Exists condition

Anonymous — Thu, 22 Sep 2016 12:20:16 GMT

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

Re: Where Exists condition

qlikview979 — Thu, 22 Sep 2016 12:28:21 GMT

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

Re: Where Exists condition

santiago_respane — Thu, 22 Sep 2016 12:32:07 GMT

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,

Re: Where Exists condition

Anonymous — Thu, 22 Sep 2016 12:33:18 GMT

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?)

Re: Where Exists condition

qlikview979 — Thu, 22 Sep 2016 12:39:05 GMT

Hi All,

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

Regards,

Mahesh

Re: Where Exists condition

Anonymous — Thu, 22 Sep 2016 12:42:19 GMT

cyn aou post sampe qvw?

are the monthfield in two tables are same Format?

Re: Where Exists condition

qlikview979 — Thu, 22 Sep 2016 12:44:10 GMT

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

Re: Where Exists condition

qlikview979 — Thu, 22 Sep 2016 12:45:59 GMT

if i remove the where condition lines fetching started

Re: Where Exists condition

sunny_talwar — Thu, 22 Sep 2016 12:49:34 GMT

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?

Re: Where Exists condition

santiago_respane — Thu, 22 Sep 2016 12:50:29 GMT

Hi Mahesh,

as Rudolf mentioned it would be easier for us to help you if you share a sample app, or at least a screenshot of your script code. This way we will find a solution faster.

Kind regards,

Re: Where Exists condition

qlikview979 — Thu, 22 Sep 2016 13:09:52 GMT

Hi All ,

Please find this file

Here I want take matching data from this three field and find the sum(qt) and count(code)

Contract

Date

Number

DATE

CONTRACT

DATA CHANGED(Modified)

Re: Where Exists condition

qlikview979 — Thu, 22 Sep 2016 15:50:18 GMT

Hi Experts,

can any one solve this.

Regards,

Mahesh

Re: Where Exists condition

qlikview979 — Thu, 22 Sep 2016 17:45:41 GMT

Thanks All,

I got it

Regards,

Mahesh

Re: Where Exists condition

santiago_respane — Thu, 22 Sep 2016 18:17:46 GMT

Hi Mahesh,

excellent news!

Please remember to close the thread by marking the post that fitted your need as correct or helpful!

Kind regards,