Join two expressions from the same table

Wed, 15 Feb 2012 17:00:18 GMT

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.

Join two expressions from the same table

tresB — Wed, 15 Feb 2012 17:46:56 GMT

hi, can't the IF be used, i mean conditional sum?

Regards, tresesco

topic Join two expressions from the same table in QlikView

Join two expressions from the same table

Join two expressions from the same table