set analysis conditional count

Tue, 16 Nov 2010 18:18:26 GMT

I want a count of sales opportunities greater than 100K, but i want the total to change based on what i select in my application. currently, i have

count( {1<Amount = {">=100000"}>} [Opportunity ID] )

this gives me total opps > 100K for all years, i want that number to change when i select 2010 or Q4.

what am i missing?

pover — Tue, 16 Nov 2010 19:14:04 GMT

Change the 1 which means to ignore all selections to a $ which means to respect all selections.

count( {$<Amount = {">=100000"}>} [Opportunity ID] )

Regards.

topic set analysis conditional count in QlikView