topic Re: Exists() question! in QlikView

Exists() question!

Thu, 10 Oct 2013 09:08:53 GMT

Hi people!

I am trying to pick records from a transactions qvd-file using the exists() function. Like this:

LOAD %Date,

%GL_Date,

'Transactions REG' as Source,

%ExecutingDepKey,

%ResponsibleDepKey,

%Project,

%EmpNo,

%ProjectTaskKey,

%Activity,

QuantityRegistered as [Registered Quantity],

BillingPriceRegisteredBase as [Registered Billing Price],

CostPriceRegisteredBase as [Registered Cost Price],

QuantityInvoiced as [Invoiced Quantity],

BillingPriceUpDownBase as [Up/Down],

QuantityUpDown as [Up/Down Quantity],

BillingPriceInvoiceBase as [Invoiced Billing Price],

OrigReveueRecognizedBase as [Revenue Recognized at Registration],

RevenueRecognizedBaseChange as [Revenue Recognized at Invoicing]

FROM

$(DataStagePath)\FACT_Transactions.qvd

(qvd)

Where Exists(%ResponsibleDepKey) OR Exists(%ExecutingDepKey)

;

But the where statement gives me all transactions. When I use only one of the conditions it works.

Can I not use exists() with an OR?

Best regards
Trond E

tresB — Thu, 10 Oct 2013 09:16:42 GMT

I am sure that you must be sure, still, to confirm let me ask - are you sure that you want exists() and not NOT exists() ?

rustyfishbones — Thu, 10 Oct 2013 09:26:42 GMT

you can say

WHERE EXISTS (%ResponsibleDepKey , %ExecutingDepKey)

jagan — Thu, 10 Oct 2013 09:27:10 GMT

HI,

Can you attach full script, it is difficult to understand.

Regards,

Jagan.

rbecher — Thu, 10 Oct 2013 09:29:17 GMT

I guess you mean AND?

Where Exists(%ResponsibleDepKey) AND Exists(%ExecutingDepKey)