How can I write this SQL in Qlikview.Please help me with this.

[#1]

If([InSite.ST_Date]<"2013-01-01 00:00:00"

Or ([InSite.ST_Date]>="2013-01-01 00:00:00"

And InSite.Inv_Amt>=1000000)

Or ([InSite.ST_Date] Is Null

And InSite.Inv_Amt>=1000000)

Or [InSite.ST_Specialty] In ("Business Owner","Corporate Executive")

Or [NBR.CUSTOMER_NAME]="INV REVENUE < $10"

Or [NBR.ITEM_ID] In ("CM_CRP_FDP"),"QUALIFIED","") AS QUALIFCATION,

[Gysbert_Wassenaar · Accepted solution]

If([InSite.ST_Date]<date#('2013-01-01 00:00:00','YYYY-MM-DD hh:mm:ss')

Or ([InSite.ST_Date]>=date#('2013-01-01 00:00:00','YYYY-MM-DD hh:mm:ss')

And InSite.Inv_Amt>=1000000)

Or (len(trim([InSite.ST_Date])) = 0

And InSite.Inv_Amt>=1000000)

Or match([InSite.ST_Specialty],'Business Owner','Corporate Executive')

Or [NBR.CUSTOMER_NAME]='INV REVENUE < $10'

Or match([NBR.ITEM_ID],'CM_CRP_FDP'), 'QUALIFIED','') AS QUALIFCATION,

[#3]

Thank you very much Gysbert.