Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Creator III
Creator III

Hi Andrew,

You can go through the attcahed application.

Hope it works!

Regards,

Tom

View solution in original post

7 Replies
Not applicable
Author

Hai,

Please send me in the form of excel doc

and tel mw what u want to look

Not applicable
Author


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
Author

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

fdelacal
Specialist
Specialist

See the qvw i atach

Regardas

thomas_skariah
Creator III
Creator III

Hi Andrew,

You can go through the attcahed application.

Hope it works!

Regards,

Tom

View solution in original post

Not applicable
Author

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
Author

Thanks a lot Tom !!