4 Replies Latest reply: Oct 10, 2014 8:59 AM by Srinivasan R RSS

    sale issue

      Scenario

       

      Purchased

         customer who bought the product a

       

       

      customer id   product id

       

      1                     1

      1                     4

      2                     2

      3                     4

       

       

       

      Product id  Product

      1                     a

      2                     b

      3                     a

      4                     c

       

      not Purchases

         customer who had not bot the product b

       

       

      Product id  Product

      1                     a

      2                     b

      3                     a

      4                     c

       

       

      1. i need customer who had not purchase the product b and customer who purchased product a, i am having two set analytics group called NOTPurchase and Purchase.

       

      I am using the following formula to find the solution.

       

      sum({<CustId-={"[NOTPurchase]::CustId"},CustId=[Purchase]::CustId>}saletotal)

        • Re: sale issue
          Prashant Sangle

          Hi,

           

          Please find attached apps.

          Might be as per your requirement.

           

          Regards

            • Re: sale issue

              Thanks max, But i need to implement with the set analytics only. product 1 listbox should not link with with product 2 list box. but both data are getting from the same table

               

              product 1 table <Purchase >(Set Analytics)

               

              product 2 table <NotPurchase >(Set Analytics)

            • Re: sale issue
              Jyothish KC

              Hi Srini,

               

              May it work;

               

              Purchase:
              LOAD * INLINE [
              Customerid,Productid
              1,1
              1,4
              2,2
              3,4
              ];


              Product:
              LOAD * INLINE [
              Productid,Product
              1,a
              2,b
              3,a
              4,c
              ];

              NoConcatenate
              TestPurchase:
              Load * Resident Purchase;

              join
              load * Resident Product
              where Product = 'a' and  Product <> 'b';

              DROP Tables Purchase,Product;

               

              Regards

              KC

               

                • Re: sale issue


                  I am getting these two tables from the database. all these selection are dynamic. user want  to see the customers who purchased one project and not purchased other product, say for example  consider the soap park avenue green purchased by set of customers and park avenue blue not purchased by the customers.