Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis conditional count

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?

1 Reply
pover
Luminary Alumni
Luminary Alumni

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

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

Regards.