1 Reply Latest reply: Feb 15, 2012 12:46 PM by Tresesco B RSS

    Join two expressions from the same table

      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.