Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
shivani_singhal
Partner
Partner

How to find count of customers whose sum of sales of one week is greater than 10000 in text object

Hi,

I have sales transaction table. And I want to find the count of customers whose sale is greater than 10000 in a week based on selection in Text Object or KPI.

Labels (2)
1 Reply
tresesco
MVP
MVP

If you are selecting a week then you may try like:

=Count( Distinct {<Customer={"=Sum(Sales)>10000"}>} Customer)