topic Re: Grouped Dimension: Employee Role in QlikView

Grouped Dimension: Employee Role

Mon, 06 Apr 2015 18:15:39 GMT

Hello,

The data table is a series of invoices as rows and has 4 columns identifying who is the Account Manager, Sales Rep, Tech Rep and Extra.

When I load the data I am presented with these 4 Dimensions but i wish to create one Dimension: "Employee", when the name is selected it will show all the rows where this employee is an Account Manager, Sales Rep, Tech Rep and/or Extra.

Let me know your thoughts,

Jarl.

Re: Grouped Dimension: Employee Role

stigchel — Mon, 06 Apr 2015 18:30:52 GMT

do a crosstable load of the 4 dimensions, something like

crosstable ( Type, Employee, 1)

I'd,

AccountManager as Account Manager,

DalesRep as Sales Rep,

See help for crosstable load

Re: Grouped Dimension: Employee Role

pokassov — Mon, 06 Apr 2015 18:54:34 GMT

Hi!

You can create another table from your data table:

Employees:

load

IDInvoice,

[Account Manager] as Employee,

'Account Manager' as Position

Resident

DataTable;

concatenate (Employees)

load

IDInvoice,

[Sales Rep] as Employee,

'Sales Rep' as Position

Resident

DataTable;

...

delete fields [Account Manager], [Sales Rep] from DataTable;

Sergey

Re: Grouped Dimension: Employee Role

Mon, 06 Apr 2015 19:54:27 GMT

Thank Sergey and Piet.