Returning customer in straight table

[#1]

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!

[ahaahaaha]

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

[#3]

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?

[kamal_sanguri]

May you want something like this.

Refer the attached Qlikview Document.

[#5]

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

[kamal_sanguri]

Use this as calculated dimension

=If(Aggr(Count(Customer),Customer)>1,Aggr(Count(Customer),Customer),NULL())

Replace Customer with your Customer or Customer ID field.