topic Re: Sum Function using two different variables in QlikView

Sum Function using two different variables

Wed, 22 Apr 2015 18:41:41 GMT

I'm attempting to use the Sum function apply two variables to arrive at an aggregated total. I have created the following expression that will work correctly for the Max Date (12/31/2014)

=Sum({$<[BROKER]={'BLKR'},[BS Date]={"$(=Date(Max([BS Date]),'MM/DD/YYYY'))"}>}[BALANCE])

However, I need to aggregate a total based on dates from the previous two months (i.e. 11/28/2014 & 10/31/2014) using the following expressiosn:

=Sum({$<[BROKER]={'BLKR'},[BS Date]={$Date={'10/31/2014'},'MM/DD/YYYY'"}>}[BALANCE])

=Sum({$<[BROKER]={'BLKR'},[BS Date]={$Date={'11/28/2014'},'MM/DD/YYYY'"}>}[BALANCE])

Does anyone have an idea on how to solve for this?

Re: Sum Function using two different variables

sunny_talwar — Wed, 22 Apr 2015 18:47:08 GMT

Not sure what exactly you are trying to do, but try this:

=Sum({$<[BROKER]={'BLKR'},[BS Date]={'10/31/2014', '11/28/2014'}>}[BALANCE])

This expression would sum up BALANCE for the two given dates (10/31/2014 and 11/28/2014) and where BROKER = BLKR

HTH

Best,

Sunny

Re: Sum Function using two different variables

Wed, 22 Apr 2015 18:49:48 GMT

Sunny,

Thanks again. This worked.

Re: Sum Function using two different variables

sunny_talwar — Wed, 22 Apr 2015 18:50:59 GMT

Awesome!