topic Re: Exist function in QlikView

Exist function

deepakqlikview_123 — Sat, 15 Nov 2014 13:02:07 GMT

Hi All,

Can you please suggest, how below expression will work,

1. if(EXISTS(INNETWORK_PHYSICIAN_ID, ROWID_OBJECT), 'IN', 'OUT') as [Physician In/Out Network],

2.WHERE EXISTS(%PHYSICIAN_ID, ROWID_OBJECT)

Thanks,

Deepak

Re: Exist function

its_anandrjs — Sat, 15 Nov 2014 13:19:19 GMT

Hi,

1. In first expression

if(EXISTS(INNETWORK_PHYSICIAN_ID, ROWID_OBJECT), 'IN', 'OUT') as [Physician In/Out Network],

if value match in this two fields then the IN value field in [Physician In/Out Network] otherwise OUT.

2. In Second expression

WHERE EXISTS(%PHYSICIAN_ID, ROWID_OBJECT)

When data match in this two fields %PHYSICIAN_ID, ROWID_OBJECT then data loads in the table

Regards

Anand

Re: Exist function

maxgro — Sat, 15 Nov 2014 13:23:16 GMT

exists (INNETWORK_PHYSICIAN_ID, ROWID_OBJECT)

returns -1 (true) if the value of ROWID_OBJECT is found in the current content of the field INNETWORK_PHYSICIAN_ID

table1:

load * inline [

INNETWORK_PHYSICIAN_ID

];

table2:

load

if(EXISTS(INNETWORK_PHYSICIAN_ID, ROWID_OBJECT), 'IN', 'OUT') as [Physician In/Out Network]

inline [

ROWID_OBJECT

];

2) using WHERE EXISTS(INNETWORK_PHYSICIAN_ID, ROWID_OBJECT) in my example you only get

you load ROWID_OBJECT if the same value already exists in INNETWORK_PHYSICIAN_ID field

Re: Exist function

its_anandrjs — Sat, 15 Nov 2014 14:20:46 GMT

In second expression

Tab1:

load * inline [

%PHYSICIAN_ID

];

Tab2:

load

inline [

ROWID_OBJECT

] WHERE EXISTS(%PHYSICIAN_ID, ROWID_OBJECT);

result will be only common records

Regards

Anand