topic Re: How to create composite key in QlikView

How to create composite key

jim_chan — Sat, 17 Sep 2016 21:52:37 GMT

Hi guys,

I need to create a composite key for these 2 tables. After loaded in the Sales Target Data. i got a synthetic key.

When i tried to create a composite key in my orders table - EmployeeID & '|' & Month & '|' & Year as Order_key, i got error as such.

How to create a composite for both of these table?

Orders:

LOAD OrderID,

Month(OrderDate) as Month,

Day(OrderDate) as Day,

OrderDate,

EmployeeID,

CustomerID,

ProductID,

APPLYMAP('Product_Details',ProductID,null()) as Product_Made,

ShipperID,

Year,

Sales,

Cost,

Quantity

FROM

[Data Source\Order.xlsx]

(ooxml, embedded labels, table is Order);

Sales_Target:

LOAD

EmployeeID,

Year,

Month,

Target

FROM

[Data Source\Sales_Target.xlsx]

(ooxml, embedded labels, table is Sheet1);

Rgds

Jim

robert_mika — Sat, 17 Sep 2016 21:59:36 GMT

Try:

EmployeeID & '|' & Month(OrderDate) & '|' & Year

make sure that both Month fields are in the same format.

jim_chan — Sat, 17 Sep 2016 22:07:04 GMT

The orderdate is orders table is dd/mm/yyyy(13/01/2016) and month is sale target table is "Jan".

is it same date format?

robert_mika — Sat, 17 Sep 2016 22:26:36 GMT

Should be fine.

Create Listbox in front end with value 'Month' to check if all entries are in the same format.