Dimension using conditional filter

[PPAT1981]

Hi Everyone,

I'm attempting to create a new dimension in a simple table by utilising the following five conditions; I want to create a 'Yes/No' category if all of the conditions satisfy the requirements. 

Can anyone give me some directions on how to create ‘IF , And ‘ function in Qlik ?

Something like this but in Qliksense  ..

If (Col_1 = (sys_A or Sys_b or Sys_c) and Col_2=(*) and Col_3=(*), ‘yes’, ‘no’)

Conditions:

Col_1 = Filter (Sys_A , Sys_B and Sys_C)
Col_2= Filer all non null values
Col_3 =filter all non null values
Col_4 =filter where value equal to 1
Col_5 = filter value euqal to cat_A

Expected Result

Col_6 = 'Yes' or 'No'

Col_1	Col_2	Col_3	Col_4	Col_5	Col_6
Sys_B	ABC	ABC	0	Cat_A	No
Sys_A	ACC		1	Cat_B	No
Sys_A	AAA	AAA	1	Cat_A	YES
Sys_C	BCA	ABC	0	Cat_A	No
Sys_A			1	Cat_A	No
Sys_B	BVA	ACC	1	Cat_B	No
Sys_A		BVA	1	Cat_A	No
Sys_D	BBA		0	Cat_A	No
Sys_A	AAA	ABA	1	Cat_A	YES