Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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]))