Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Creator III
Creator III

Where Condition

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

2 Replies
sivakumar1994
Contributor III
Contributor III

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)') ;

dapostolopoylos
Creator III
Creator III

Try this:

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

 

Father/Husband/BI Developer