topic Re: Returning customer in straight table in QlikView

Returning customer in straight table

Wed, 07 Jun 2017 13:54:51 GMT

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

ahaahaaha — Thu, 08 Jun 2017 07:56:22 GMT

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

Mon, 12 Jun 2017 12:57:39 GMT

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_sanguri — Mon, 12 Jun 2017 13:20:37 GMT

May you want something like this.

Refer the attached Qlikview Document.

Re: Returning customer in straight table

Mon, 12 Jun 2017 13:35:38 GMT

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

Re: Returning customer in straight table

kamal_sanguri — Tue, 13 Jun 2017 04:35:42 GMT

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.