topic Set Analysis Expresion Problem in QlikView

Set Analysis Expresion Problem

Thu, 13 Jan 2011 17:16:15 GMT

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!

Set Analysis Expresion Problem

Thu, 13 Jan 2011 17:24:38 GMT

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

Set Analysis Expresion Problem

Thu, 13 Jan 2011 18:59:52 GMT

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