Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Returning customer in straight table

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!

5 Replies
ahaahaaha
Honored Contributor

Re: Returning customer in straight table

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

Not applicable

Re: Returning customer in straight table

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
Valued Contributor

Re: Returning customer in straight table

May you want something like this.

Capture.PNG

Refer the attached Qlikview Document.

Not applicable

Re: Returning customer in straight table

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

help.PNG

kamal_sanguri
Valued Contributor

Re: Returning customer in straight table

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.

Community Browser