topic Using Exists in QlikView

Using Exists

Sun, 11 Mar 2012 14:27:19 GMT

Hi All,

I am trying to use the following script to load but it won't work:

QUALIFY*;

UNQUALIFY BillingIDCustomerID,

LOAD *, BillingID+' '+CustomerID AS BillingIDCustomerID

FROM

WHERE EXISTS(VisitID)

Basically, I want to only pull records where the VisitID is loaded in QlikView, but when I look at table viewer, the information density on BillingIDCustomerID field is 0. Any ideas? Thanks in advance for your help!

Using Exists

Sun, 11 Mar 2012 15:10:00 GMT

Try this:

BillingID&' '&CustomerID AS BillingIDCustomerID

Using Exists

Oleg_Troyansky — Sun, 11 Mar 2012 16:34:44 GMT

I believe the problem is caused by Qualify. Because of the qualification, your field VisitID is now called differently (with the qualifier), hence Exists never returns true and nothing is being loaded.

Try unqualifying VisitID.