Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm trying to combine 2 calculations within the same expression. I have one dimension (Year) and for Year 2003 and 2004 I need to perform one calculation and for the other Years another. I need to display the results on the same table. I'm currently using this expression:
SUM({<YEAR = {'2003', '2004'}>} AGGR(SUM(AVG(SALES), ID, YEAR, MONTH)) /
SUM({<YEAR = {'2003', '2004'}>} AGGR(SUM(AVG(AMOUNT), ID, YEAR, MONTH))
&
SUM({<YEAR = {2005, '2006', '2007'}>} AGGR(SUM(SUM(SALES), ID, YEAR, MONTH)) /
SUM({<YEAR = {'2005', '2006', '2007'}>} AGGR(SUM(SUM(AMOUNT), ID, YEAR, MONTH))
Qlikview will compile only the second calculation and discard the first one.
Any help would be much appreciated. Thanks in advance.
hi, can't the IF be used, i mean conditional sum?
Regards, tresesco