0 Replies Latest reply: Feb 19, 2014 5:54 AM by Nikolaos Kavroulakis RSS

    Aggr function set analysis VS if

      Hi there,


      Can anyone explain whats the difference between these 2 expressions:


      1) sum({<Confirmed={'1'}>}aggr((($(vTimeSheetTime)+$(vApprovedTime)+$(vForecast))*[Project Day Rate]),ProjectCode,ConsultingMonth,Product,Sector))




      2) sum(aggr(if(Confirmed=1,(($(vTimeSheetTime)+$(vApprovedTime)+$(vForecast))*[Project Day Rate])),ProjectCode,ConsultingMonth,Product,Sector))


      It seems my report does work only with the 2) expression even though i don't have any confirmed codes at all.

      If I use the first expression I just get the total of the current selection and qlikview seems to ignore set analysis.


      Kind Regards,