topic Filtering data in script in QlikView

Filtering data in script

Fri, 20 Apr 2012 01:18:37 GMT

Hi All,

I am using the script below to pull data from a table. I only want to pull data where TranDateTime > 2008 or if the AccountNumber exists in the Account table. I have a QVD called Accounts.qvd that has AccountNumber but am not sure how to use an OR clause in the script. Any idea how to do this?

Thanks in advance for your help!

Transactions :

LOAD

AccountNumber,

TranDateTime,

Amount

FROM (qvd)

WHERE YEAR(TranDateTime) > 2008 OR AccountNumber IN(LOAD AccountNumber FROM )

Filtering data in script

Fri, 20 Apr 2012 04:09:44 GMT

You can use the 'Exists' to check whether the account number exists in the QVD.

Regards,

Raj.

Filtering data in script

jagan — Fri, 20 Apr 2012 05:46:42 GMT

Hi,

Try script below

Accounts:

LOAD

FROM (qvd)

Transactions :

LOAD

AccountNumber,

TranDateTime,

Amount

FROM (qvd)

WHERE YEAR(TranDateTime) > 2008 OR EXISTS(AccountNumber);

Hope this helps you.

Regards,

Jagan.

Filtering data in script

Fri, 20 Apr 2012 13:01:09 GMT

Thanks Jagan, is there any other method? I am relucatat to use EXISTS as it checks record by record and so is slow. Thanks for your help!

Filtering data in script

jagan — Fri, 20 Apr 2012 13:40:24 GMT

Hi,

As per my knowledge, using Exists() is the best way, also I think it is the only way. Exists is a faster way, since you need subquery like feature, but in qlikview scripting there is no such concept.

Regards,

Jagan.