Sum two different Set Analysis Expressions

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

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.

Re: Sum two different Set Analysis Expressions

sunny_talwar — Tue, 27 Mar 2018 14:00:04 GMT

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

topic Sum two different Set Analysis Expressions in QlikView

Sum two different Set Analysis Expressions

Re: Sum two different Set Analysis Expressions