topic Re: Basic Question in QlikView

Basic Question

jadams123 — Wed, 25 Nov 2020 16:16:04 GMT

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

Clever_Anjos — Sun, 09 Oct 2016 02:25:09 GMT

Probably

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

sunny_talwar — Sun, 09 Oct 2016 04:47:07 GMT

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 — Sun, 09 Oct 2016 05:28:45 GMT

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])