Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

eustisab
New Contributor III

set analysis multiple conditions

i have two expressions that i want to combine.

1. (count(aggr(if(Sum([Aggr nOffered])>1,num(Sum([Aggr nOffered]),vFormatSeconds2), null()) ,[Formatted CLI]) ))

counting the Formatted CLI with sum Aggr nOffered field> 1

2. count(distinct{<[Participant Purpose]  ={'customer'},[Conversation Direction]= {'inbound'}>} [Formatted CLI])

counting the Formatted CLI with [Participant Purpose]  ={'customer'},[Conversation Direction]= {'inbound'}

3. expected set analysis should be:

counting the Formatted CLI with Sum Aggr nOffered field> 1 ,[Participant Purpose]  ={'customer'},[Conversation Direction]= {'inbound'}

please...

1 Solution

Accepted Solutions

Re: set analysis multiple conditions

May be this

Count(DISTINCT {<[Participant Purpose]  = {'customer'}, [Conversation Direction] = {'inbound'}, [Formatted CLI] = {"=Sum([Aggr nOffered]) > 1"}>} [Formatted CLI])

2 Replies

Re: set analysis multiple conditions

May be this

Count(DISTINCT {<[Participant Purpose]  = {'customer'}, [Conversation Direction] = {'inbound'}, [Formatted CLI] = {"=Sum([Aggr nOffered]) > 1"}>} [Formatted CLI])

thi_pham
Contributor

Re: set analysis multiple conditions

Just have an idea that make it a little easier by creating a new table with 2 columns  are:

1. [Formatted CLI]

2. Flag_Aggr_nOffered = if (sum Aggr nOffered field> 1, 1, 0)

(you can do it in data load)


Then, the set analysis in 3rd will be simple:

count(distinct{<[Participant Purpose]  ={'customer'},[Conversation Direction]= {'inbound'}, Flag_Aggr_nOffered = {1} >} [Formatted CLI])

Hope it help.

Community Browser