Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
panwipa2528
Contributor III
Contributor III

Need help to suggest about use Set analysis in dimension

1. I have raw data as & sample as attach file

2. Table raw data just show all data

3. Table 2 Show Member

4. Table 3 Need help, find active member condition is
      4.1 [Member Status] =1
      4.2 sum(Sale) >0
 
If you have any question please let me know.

1 Solution

Accepted Solutions
Vegar
MVP
MVP

Try this expression

 

 

 

=If(aggr(([Member Status]=1) * (Sum(Sale)>0), [Member ID]),
   'Member', 
   'Non Member')

 

 

 

image.png 

View solution in original post

1 Reply
Vegar
MVP
MVP

Try this expression

 

 

 

=If(aggr(([Member Status]=1) * (Sum(Sale)>0), [Member ID]),
   'Member', 
   'Non Member')

 

 

 

image.png