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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
jadams123
Creator
Creator

Basic Question

Hi I want to sum all sales but not include a customer type. How do i do that?

I can sum all sales...but not exclude...

=Sum({$<CUSTOMER_TYPE={'*'} - {ITC}>}, 

($<GLYEAR = {$(#=MAX(GLYEAR))}>) AMOUNT )

Thanks,

Joe

3 Replies
Clever_Anjos
Employee
Employee

Probably

=Sum({$<CUSTOMER_TYPE={'*'} - {"ITC"} ,  GLYEAR = {$(#=MAX(GLYEAR))} AMOUNT )

sunny_talwar

cleveranjos‌ - You missed the closing >}

=Sum({$<CUSTOMER_TYPE = {'*'} - {"ITC"},  GLYEAR = {$(#=MAX(GLYEAR))}>} AMOUNT)

or even this should work:

=Sum({$<CUSTOMER_TYPE = - {"ITC"},  GLYEAR = {$(#=MAX(GLYEAR))}>} AMOUNT)

Anil_Babu_Samineni

joe adams wrote:

Hi I want to sum all sales but not include a customer type. How do i do that?

From this, you are looking this

Aggr(Sum(sales), - [Customer Type])

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful