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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
harveenkaur
Contributor III
Contributor III
‎2018-11-28 01:35 AM

Using 2 aggregate functions

Hi

I want to count cities having sum(Quantity)>1000 and sum(Sales)>1200 for the maximum month year in Date( In sample Data :- Sept. 2018)

Sample Data:

CityQuantitySales(Rs)Date
C11000200012-Sep-18
C2123121231013-Sep-18
C31212122312-May-18
C41212131330-Aug-17
C112121212320-Sep-18
C2121131308-Nov-18
C312113209-Nov-17
317 Views
0 Likes
0 Replies