3 Replies Latest reply: Nov 4, 2015 7:31 AM by Kilian Riera RSS

    Set analysis

    Kilian Riera

      Hi there, i'm trying to use set analyssis instead of "if" but have a issue, the quotes on the part of the DateNum makes the rest of the data between them appear as grey text.


      so no clue how to do "if date is less than"  or if date is between dates and so on. Could any help me?


      thanks!


      Sum({<Year=, Month=, Quarter=, Week=, DateField=, DateNum={">=$(=Num($(=vToDate& 'Start(Max(DateNum))')))<=$(=Max(DateNum))"}>} Sales)


      DateNum={">=$(=Num($(=vToDate& 'Start(Max(DateNum))')))<=$(=Max(DateNum))"}

        • Re: Set analysis
          Sunny Talwar

          Not sure what is Start function used for? What are you trying to do with this part of the code -> 'Start(Max(DateNum))'

          • Re: Set analysis
            Jonathan Dienst

            I cannot understand what you are trying to achieve with the (nonexistant) Start() function. But you probably need something like this to get dates in a range.

             

            DateNum={">=$(=vToDate) <=$(=Max(DateNum))"}

            • Re: Set analysis
              Kilian Riera

              I've a fact table:

               

              Issuenum;startdate;endate

               

              When i do the analyis and i do select the current month (ex november), i get all the issues received on the startdate november. the status can be opened closed pending...

               

              but if i want to do a table where i can show all data from november and those pending from previous month. i can't make it 'cos i'm already filtering by "november"

               

              any idea?