If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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’)
Col_1 = Filter (Sys_A , Sys_B and Sys_C)Col_2= Filer all non null valuesCol_3 =filter all non null valuesCol_4 =filter where value equal to 1Col_5 = filter value euqal to cat_A
Col_6 = 'Yes' or 'No'