Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Eli181
Contributor II
Contributor II

Set Analysis with Multiple Conditions

Hi.

I spent a couple of days to address this issue ... with no luck. Could anyone help:

I would like to develop a measure (or a variable) that

  1. DISTINCT COUNT customers when

Value in Column A = 1

AND

Value in Column B1 <> 1 OR Value in Column B2 <>1

AND

Value in Column C1 <> 1 OR Value in Column C2 <>1

 

I tried

count(distinct{$<Column A={'1'},

<Column B1-={'1'}>+<Column B2-={'1'}>,

<Column C1-={'1'}>+<Column C2-={'1'}>}Customer)

 

Buy it gives me an Error Expression MEssage.

Thank you very much for your help.

E

Labels (2)
1 Solution

Accepted Solutions
Kashyap_R
Partner - Specialist
Partner - Specialist

Hi 

Try this

Count(distinct{<Column A={'1'}>*(<Column B1-={'1'}>+<Column B2-={'1'}>)*

(<Column C1-={'1'}>+<Column C2-={'1'}>)}Customer)

 

Hope it helps 

Thanks

 

 

 

 

 

Thanks and Regards
Kashyap.R

View solution in original post

3 Replies
Anil_Babu_Samineni

Perhaps this?

Count(distinct If([Column A]=1 and ([Column B1] <> 1 OR [Column B2] <>1) and ([Column C1] <> 1 OR [Column C2] <>1), Customers))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Kashyap_R
Partner - Specialist
Partner - Specialist

Hi 

Try this

Count(distinct{<Column A={'1'}>*(<Column B1-={'1'}>+<Column B2-={'1'}>)*

(<Column C1-={'1'}>+<Column C2-={'1'}>)}Customer)

 

Hope it helps 

Thanks

 

 

 

 

 

Thanks and Regards
Kashyap.R
tresesco
MVP
MVP

Try like:

count(distinct{$<Column A={'1'}>*

(<Column B1-={'1'}>+<Column B2-={'1'}>)*

(<Column C1-={'1'}>+<Column C2-={'1'}>)}Customer)