Having trouble translating statement from SQL to Qlik Sense
I am brand new to Qlik Sense and I am having trouble converting the following statement from SQL:
(([Does the client have a disabling condition?(1012)]="Yes (HUD)") Or (Not(IsNull([Disability Type]))))
[Residence Prior to Project Entry(43)]="Place not meant for habitation (HUD)";"Emergency shelter, including hotel or motel paid for with emergency shelter voucher (HUD)";"Safe Haven (HUD)";"Interim Housing")
[On the night before did you stay on the streets, ES or SH?(3247)]="Yes"
[Entry Exit Provider Program Type Code]="Emergency Shelter (HUD)";"Safe Haven (HUD)";"Street Outreach (HUD)")
([Approximate date homelessness started3248)]<=[Entry Exit Entry Date];-365))
([Regardless of where they stayed last night - Number of times the client has been on the streets, in ES, or SH in the past three years including today(3249)]="Four or more times (HUD)")
([Total number of months homeless on the street, in ES or SH in the past three years(3250)]="More than 12 months (HUD)";"12"))
Can someone help? I am trying to display whether a person is Chronic or Non Chronic based on the above conditions.