topic Re: Two different field values in one field in QlikView

Two different field values in one field

Tue, 19 Sep 2017 19:06:18 GMT

Hello all,

I need help in below requirement.I have a field Manager from Table-1 and Employee from Table-2 .Now i need a new field Customer where it should have all the values of Manger and Employee.

When i select a value in Customer, all the associated values in both Manager and Employee should show up.

Ex: Manager Employee

AAA CCC

BBB XXX

CCC DDD

AAA AAA

DDD BBB

AAA YYY

ZZZ AAA

Now when i select AAA in Customer field i need the result as below

Manager Employee

AAA CCC

AAA AAA

AAA YYY

ZZZ AAA

Thanks in Advance.

Re: Two different field values in one field

aarkay29 — Tue, 19 Sep 2017 19:32:57 GMT

PFA

Re: Two different field values in one field

Tue, 19 Sep 2017 19:51:49 GMT

Thanks Aar Kay for the quick response.

In my real data, Manager and Employee fields comes from two different tables .Manager is in Dimension table where as Employee in fact table.So when i select a value in customer field associated measures from fact table should also reflect.

Hope i am clear with my requirement.

Re: Two different field values in one field

aarkay29 — Tue, 19 Sep 2017 20:33:09 GMT

Can you please post sample data to replicate you model so that I can give you the exact solution

or screenshot of your datamodel to get an idea.

Re: Two different field values in one field

Wed, 20 Sep 2017 00:38:24 GMT

PFA

Re: Two different field values in one field

aarkay29 — Wed, 20 Sep 2017 18:59:06 GMT

May be this

DirectCustomers:

Load

%Customer_Account_ID,

[Customer Name] as Direct_Customer

Resident

Customers;

Concatenate(DirectCustomers)

Load

%Customer_Account_ID,

[Referral Customer Name] as Direct_Customer

Resident

Orders;