topic Re: Where Clause Limitations in QlikView

Where Clause Limitations

bjsellers57 — Wed, 26 Oct 2016 13:16:39 GMT

I have a very large data set that I built in several QVDs and now in my main application I need to pull data from those QVD's with a pretty extensive where clause. I am pulling 573 different account in so the where clause to list those Accounts created a 9,368 character line: (i.e. Where Match([Customer Account], 'Account1', 'Account2', 'Account3', ..., 'Account571', 'Account572','Account_573')) Please understand these are not the account names as each one is unique, no ways to combine names to make where clause smaller

Re: Where Clause Limitations

maxgro — Wed, 26 Oct 2016 16:11:23 GMT

you can load the accounts in a table and use a where exists ([Customer Account])

Re: Where Clause Limitations

el_aprendiz111 — Wed, 26 Oct 2016 22:10:46 GMT

Hi Bernard

1-Example:

[SAMPLE]:

LOAD*, KeepChar([Customer Account], '0123456789') as id_Account;

LOAD * Inline

[

Customer Account, Data, Field

Account1, 187, F

Account2, 346, U

Account3, 2286, Z

Account4, 493, A

Account5, 4607, O

Account6, 4906, G

Account7, 1795, O

Account8, 2533, U

Account9, 2959, D

Account10, 2112, P

Account500, 11111, L

Account732, 143, I

Account733, 2412, I

Account734, 1377, P

Account735, 3568, W

Account736, 4190, D

Account750, 3935, G

Account738, 2504, F

Account800, 1238, D

Account801, 4268, I

Account841, 2291, A

];

QUALIFY*;

LOAD * Resident SAMPLE

Where id_Account >= 500 AND id_Account <= 750;

Re: Where Clause Limitations

bjsellers57 — Fri, 28 Oct 2016 10:40:46 GMT

Thank you very much, I will try this

Bernie Sellers

Analytic Consultant

(p)410.884.2182