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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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!!!