Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Creating a dimension...

Hi

I would like to create a Employee Dimension in the load script where an employee is assigned to the Branch where he has made the Most sales.

So, using the source data below, Alex would be assigned to BranchCode 514 only; Christopher would be assigned to Branch 626 etc.

Source Data:

Source Data.JPG

Thanks!!

1 Solution

Accepted Solutions
thomas_skariah
Contributor III

Re: Creating a dimension...

Hi Andrew,

You can go through the attcahed application.

Hope it works!

Regards,

Tom

7 Replies
Not applicable

Re: Creating a dimension...

Hai,

Please send me in the form of excel doc

and tel mw what u want to look

Not applicable

Re: Creating a dimension...


Not sue how to add the data - hope this is suitable

























































EmployeeBranchCodeSalesAmount
Robert399714
Robert51623 242
Robert6166714
Christopher62648 883
Christopher16471 035
Lucia6516 455
Lucia1647672
Lucia2352672
Alex500714
Alex514134 810
Alex6595714
Not applicable

Re: Creating a dimension...

Hi - how do I attached an Excel doc. Cant seem to find an option to do this....

fdelacal
Valued Contributor

Re: Creating a dimension...

See the qvw i atach

Regardas

thomas_skariah
Contributor III

Re: Creating a dimension...

Hi Andrew,

You can go through the attcahed application.

Hope it works!

Regards,

Tom

Not applicable

Re: Creating a dimension...

Thanks.

How would I go about doing this in the load script so that it creates a Dimension with just two columns - ie Employee and BranchCode

Not applicable

Re: Creating a dimension...

Thanks a lot Tom !!

Community Browser