Qlik sense : set analysis (and / or)

[#1]

HI Experts,

How do I use an and / or in an set analysis expression in qlik sense.

Thanks

Erenst

[devarasu07 · Accepted solution]

Hi,

Refer below example,

1) =Count({$<Type={'Accepted Lead'}>+<Type={'Instructed Lead'},ProductId-={'5'}>}TicketId)

above set expression will counting where TicketId is Type 'Accepted Lead' OR 'Instructed Lead':

3) Count(if(Completion_Date <= Due_Date and (Source = 'Assignments' or (Source = 'Tasks' and TASK_TYPE = 'Product')),Task_ID_New))

if we convert above expression into Set analysis it will be look like below,

count({<Source={'Assignments'},ID={"=Completion_Date<=Due_Date"}>+<Source={'Tasks'},TASK_TYPE={'Product'},ID={"=Completion_Date<=Due_Date"}>} Task_ID_New)

also check this beginners material

Hope this helps to you

Regards,

Deva

[#3]

Thanks for the quick response, just a question, what is the "ID" field you use.

count({<Source={'Assignments'},  ID=  {"=Completion_Date<=Due_Date"}>+<Source={'Tasks'},TASK_TYPE={'Product'},ID={"=Completion_Date<=Due_Date"}>} Task_ID_New)

Thanks

Erenst

[devarasu07]

Hi,

It's RowNo()  AS  ID field from back-end script. Thanks

[#5]

Thanks you

[devarasu07]

Hi,

If it's all ok then can you close this thread by marking correct answer or mark it assumed answer. Thanks

Regards, Deva