topic Re: Can you use multiple where clauses? in QlikView

Can you use multiple where clauses?

bobbydave — Fri, 20 Nov 2020 18:02:30 GMT

Original where clause

Load *

FROM
[$(vQVDPath)\E_Finance_Reports_Rep14.QVD] (qvd)
where len(source_country_code)>0
and ApplyMap('MapFordAgents', source_country_code &'-'& Agent)=1;
;

I want to further reduce the load with Dates greater than 2014

FROM
[$(vQVDPath)\E_Finance_Reports_Rep14.QVD] (qvd)
where len(source_country_code)>0 and where Year(Policy_New_Business.AccountingPeriod) > '2014'

and ApplyMap('MapFordAgents', source_country_code &'-'& Agent)=1;
;

Can you add a 2nd where clause?

Re: Can you use multiple where clauses?

Anonymous — Wed, 07 Oct 2015 09:55:45 GMT

No, you can only have one where clause per Load.

Re: Can you use multiple where clauses?

bobbydave — Wed, 07 Oct 2015 09:56:42 GMT

Thanks for clarifying

Re: Can you use multiple where clauses?

Tue, 31 Jan 2017 20:51:10 GMT

Hello,

is there a turn around ?

can we have multiple load containing each 1 where clause ?

many thanks !