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: 
HitcH
Partner - Contributor II
Partner - Contributor II

Set analysis with more viariables

Seems strange to me, but I couldn't find similar topics.

 

Let's consider two variables and one value:

GenderHairNumber
MaleBlonde4
MaleBrown6
FemaleBlonde6
FemaleBrown2
FemaleRed4

 

I'd like to select with set analysis  only "Male" and "Brown". The expression I'm using is:

sum({$<[Gender]={Male}>*<[Hair]={Brown}>} Number)

But obviously this is not working (else you wouldn't be reading this 😄 )

 

Any help please?

 

Labels (2)
1 Solution

Accepted Solutions
Taoufiq_Zarra

like ?

=sum({$<[Gender]={'Male'},[Hair]={'Brown'}>} Number)

@HitcH  

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

2 Replies
Taoufiq_Zarra

like ?

=sum({$<[Gender]={'Male'},[Hair]={'Brown'}>} Number)

@HitcH  

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
HitcH
Partner - Contributor II
Partner - Contributor II
Author

Thanks a lot, I found "*" on a guide on the net, I guess it was wrong 🙂

 

@Taoufiq_Zarra