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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis Expresion Problem

Im trying to do an intersection expresion.

This is the one:

Count ({<[Lead Request Type] = {'Mkt Oppty'}> * <AñoOppsCrea = {$(AñoAnalisis)} > }DISTINCT [OPPS ID])

But the expresion doesnt seems to work. The results its always the counting of the first dimention that i put in the expresion.

Can someone help me?

Thanks!

1 Solution

Accepted Solutions
Not applicable
Author

It Works!!!! THanks a Lot!!!

View solution in original post

2 Replies
Not applicable
Author

Try this

Count ({<[Lead Request Type] = {'Mkt Oppty'}, AñoOppsCrea = {$(AñoAnalisis)} > }DISTINCT [OPPS ID])

Note : Union or intersection operators are explicitly specified within the values of a dimension. If your set analysis includes more than one dimension, it takes the intersection of the dimensions by default.

Upload your app if the above doesn't work

Not applicable
Author

It Works!!!! THanks a Lot!!!