topic Re: Where Condition in QlikView

Where Condition

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi Expertise

I am writing the where condition please correct if this is wrong

RESIDENT Depart
Where [When Found] = 'Production' and Branch= not null
AND Closed>= date('$(vReportYearStart)') ;

The requirement is like found should be production and branch should not be blank and closed should be gretaer than startyear.

Thanks in Advance

Re: Where Condition

sivakumar1994 — Thu, 28 Feb 2019 18:51:47 GMT

Try this instead and let me know the status

RESIDENT Depart
Where [When Found] = 'Production' and Len(Trim(Branch)) = 0
AND Date(Closed) >= date('$(vReportYearStart)') ;

Re: Where Condition

dapostolopoylos — Tue, 26 Feb 2019 12:12:23 GMT

Try this:

RESIDENT Depart
Where [When Found] = 'Production' and (Not IsNull(Branch))
AND Closed>= date('$(vReportYearStart)') ;