5 Replies Latest reply: Jun 13, 2017 12:35 AM by Kamal Kumar Sanguri RSS

    Returning customer in straight table

    Robin Stoevelaar

      Hi everyone,

       

      I have a table in Excel with CustomerID and OrderID and ofcourse some other datasets.

      I also have a straight table in Qlikview where I have my customer profile (M/F, Age etc.) per customer segment as a dimension (Consumer, corporate etc.)

      What I want to achieve is that exact same table, but without the customer segment dimension but with Returning customer and new customer as my dimension.

       

      How do I do this?

       

      Thanks in advance!

        • Re: Returning customer in straight table
          Andrey Khoronenko

          Hi,

           

          I understand that in any case you will have to link these two tables. If you have common fields (CustomerID, Customer, etc.), then you can attach Excel table to the common field at Qlik table (load Excel table in Qlik). If there are no common fields, you will have to manually create the mapping table and then use the it to load the Excel table in Qlik.

           

          Regards,

          Andrey

          • Re: Returning customer in straight table
            Robin Stoevelaar

            Thank you for your answer Andrey,

             

            The tables are linked where they were allowed to link. The problem still exists.

            My wish is to see the profile of new and returning customers.

            I have a Orders tab in my Excel, that was loaded in Qlikview. In that Orders tab, I have the following collumns:

            OrderID, CustomerID, Total Sales, ProductID

             

            I have another Excel that was loaded in, with all customerID's.

             

            I can imagine that I need a calculated dimension. I want it to see if the CustomerID placed an order before. An example:

             

            OrderID, CustomerID, Total Sales, ProductID


            1               1                    $10              C5

            2               4                    $20              K8

            3               6                    $30              Y5

            4               4                    $10              L3

            5               3                    $10              U9

            6               8                    $20              E2

            7               1                    $30              O9

            8               9                    $10              M1



            I want the calculated dimension to see that customerID 1 and 4 both have several appearances so when I have a Straight table with customer profiles, I see a difference between the new and returning customers.


            Can you help me with that?

            • Re: Returning customer in straight table
              Kamal Kumar Sanguri

              May you want something like this.

              Capture.PNG

               

               

              Refer the attached Qlikview Document.

              • Re: Returning customer in straight table
                Robin Stoevelaar

                I would like something like this. Where the error is, I want the calculated dimension that calculate the returning customers.

                 

                help.PNG