Sum two different Set Analysis Expressions

[terry_kim1]

Hi all,

I'm a Qlikview newbie and have been struggling with below.

I want to create a table that has the following:

//For Jan and Feb

Sum({<Year={$(=Max(Year))}, Month={'Jan','Feb'}, [Selling Wholesaler]={'Company A', 'Company B'}, [Customer Stream]-={'Samples'}>} [Total Quantity]*[Construction_ASP])

//For Mar - Dec

sum({<Year={$(=Max(Year))}, Month-={'Jan','Feb'} >} [ADS_NET_UNIT] * [Construction_ASP])

The expressions above work fine individually but cannot seem to put them together to display in one table.

Please help.

[sunny_talwar]

May be this

RangeSum(

Sum({<Year={$(=Max(Year))}, Month={'Jan','Feb'}, [Selling Wholesaler]={'Company A', 'Company B'}, [Customer Stream]-={'Samples'}>} [Total Quantity]*[Construction_ASP]),

Sum({<Year={$(=Max(Year))}, Month-={'Jan','Feb'} >} [ADS_NET_UNIT] * [Construction_ASP]))