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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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