topic Re: Help Creating Salesperson from 2 Tables in QlikView

Help Creating Salesperson from 2 Tables

Fri, 31 Oct 2014 15:02:31 GMT

I have EmployeeID in my facts table and the employee dimensions table. Employee name is in the dimensions table. I want to be able to show both the employee names as well as the salespeople (just those associated to orders/opportunities in the facts table) . This would be very simple if I had the actual employee names in the facts table.

How do I get the employee names in the facts table while preserving a field for all employees?

Re: Help Creating Salesperson from 2 Tables

MK_QSL — Fri, 31 Oct 2014 15:07:30 GMT

Employee:

Mapping Load EmployeeID, EmployeeName From EmployeeTable;

FactTable:
Load

Field1,

Field2,

Applymap('Employee',EmployeeID,'Unknown') as EmployeeName,

Field3,.....

From FactTableName;

===================================

FactTable:

Load * From FactTableName;

Left Join

Load * From EmployeeTableName;

Re: Help Creating Salesperson from 2 Tables

shambhub — Fri, 31 Oct 2014 15:08:00 GMT

David,

Please can you explain me your question with example ? So that I can look into .

Re: Help Creating Salesperson from 2 Tables

Fri, 31 Oct 2014 16:10:32 GMT

Facts Table:

Opportunities:

LOAD "Oppo_PrimaryCompanyId" as CompanyID,

"Oppo_AssignedUserId" as EmployeeID,

"Oppo_Description",

"Oppo_Type",

"Oppo_Product" as Product,

...

Dimension table:

Employees:

LOAD "User_UserId" as "EmployeeID",

// "User_LastName",

// "User_FirstName",

"User_FirstName" & ' ' & "User_LastName" as "Employee Name";

...

I need a field that shows only users associated with at least 1 Opportunity (AKA Salespeople).

Thoughts?

Re: Help Creating Salesperson from 2 Tables

MK_QSL — Fri, 31 Oct 2014 16:11:49 GMT

Opportunities:

LOAD "Oppo_PrimaryCompanyId" as CompanyID,

"Oppo_AssignedUserId" as EmployeeID,

"Oppo_Description",

"Oppo_Type",

"Oppo_Product" as Product,

Left Join

Employees:

LOAD "User_UserId" as "EmployeeID",

"User_FirstName" & ' ' & "User_LastName" as "Employee Name";

Re: Help Creating Salesperson from 2 Tables

Fri, 31 Oct 2014 16:16:01 GMT

Thanks for the reply, Manish.

I need a separate field that contains ONLY salespeople, as well as a field that contains all employees. A left join does not offer that.

Re: Help Creating Salesperson from 2 Tables

MK_QSL — Fri, 31 Oct 2014 17:03:49 GMT

Can you elaborate little more please?