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 |