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!