5 Replies Latest reply: May 25, 2012 8:13 AM by Jonathan Dienst RSS

    If and set analysis

      Hi everyone

       

      I am having problems excluding selections when using if together with a set analysis like this

      if(_sys_flag_Dag <> 'Igår',

           sum({1<$(sFilterToday)>} [InqueriesCount]),

                sum({1<$(sFilterYD)>} [InqueriesCount])

      )

       

      Note the 1's that should include all data!

       

      The expression works well if I don't do any selections but when I select something in the app only that selection displays in the graph (the 1's should prevent this). When I run the expressions one by one (removing the if statement) the selections does not affect the expression!

       

      Any ideas?

       

      Many thanks!

      /Mats