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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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
Partner - Master
Partner - Master

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

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

Regards.