Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
terry_kim1
New Contributor

Sum two different Set Analysis Expressions

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.

Tags (3)
1 Reply

Re: Sum two different Set Analysis Expressions

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