topic Re: sum question in QlikView

sum question

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

so this is my pivot table. I have expanded "Customer Claim" Code Group.

my formula for Sales_CY (Invoice only) is:

Sum( {$<GLYEAR = {$(#=MAX(GLYEAR))}, TRX_TYPE = {'Invoice'}, CREDIT_CODE = {'Yes'}>} AMOUNT )

Thanks,

sunny_talwar — Wed, 26 Oct 2016 16:29:14 GMT

May be try this:

Sum(TOTAL {$<GLYEAR = {$(#=MAX(GLYEAR))}, TRX_TYPE = {'Invoice'}, CREDIT_CODE = {'Yes'}>} AMOUNT)

jadams123 — Thu, 27 Oct 2016 14:05:10 GMT

perfect...it worked beautifully.

sunny_talwar — Thu, 27 Oct 2016 16:07:48 GMT

Awesome, if you got what you wanted, please close this thread by marking correct answer.

Best,

Sunny