2 Replies Latest reply: Jun 19, 2014 12:01 PM by Jerry Lau RSS

    set analysis for data without association

    Jerry Lau

      hello all,

       

      i hv a sales table, with invoice date and is used as master calendar

      member is in sales table to indicate the buyer

      on the other hand, there is a member master, with join date inside

       

      sales:

      inv_date, inv_date_year, inv_month, member_id ...

       

      member:

      member_id, join_date, ..., sumcount

       

      i want to count the # of new join member within a selected period (using inv_date)

      but i cant count those member who join but make no purchase at all, even using set analysis

       

      Sum(

         {$<joint_date = { ' >=$(=Min(inv_date)) <=$(=Max(inv_date)) ' }>}

         sumcount

      )

       

      is there no way for me to do the counting using the same data model?

       

      thanks

        • Re: set analysis for data without association
          Stefan Wühl

          As I read your request, you select a period in sales table field inv_date. This will associate only members in member table that have record in sales table, as long as you use the default state for your analysis. But what about using the set identifier 1?

           

          Sum(

             {1<joint_date = { ' >=$(=Min(inv_date)) <=$(=Max(inv_date)) ' }>}

             sumcount

          )

           

          or disregarding the explicit selections on inv_date:

           

          Sum(

             {$<joint_date = { ' >=$(=Min(inv_date)) <=$(=Max(inv_date)) ' }, inv_date= >}

             sumcount

          )

            • Re: set analysis for data without association
              Jerry Lau

              hi

               

              your answer is correct, but i forget to tell u that, my expression is a chart expression

               

              the solution works perfectly in a text object expression

               

              but will still be affected by dimensions if put inside a chart expression

               

              in my case, my expression "count" is under dimension "inv_date"

               

              so putting 1 as set identifier seems not working (member without sales still not shown under certain period)