Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
PPAT1981
Contributor II
Contributor II

Dimension using conditional filter

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_1Col_2Col_3Col_4Col_5Col_6
Sys_BABCABC0Cat_ANo
Sys_AACC 1Cat_BNo
Sys_AAAAAAA1Cat_AYES
Sys_CBCAABC0Cat_ANo
Sys_A  1Cat_ANo
Sys_BBVAACC1Cat_BNo
Sys_A BVA1Cat_ANo
Sys_DBBA 0Cat_ANo
Sys_AAAAABA1Cat_AYES
Labels (3)
0 Replies