topic Creating a dimension... in QlikView

Creating a dimension...

Tue, 16 Oct 2012 08:51:52 GMT

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:

Thanks!!

Tue, 16 Oct 2012 08:59:21 GMT

Hai,

Please send me in the form of excel doc

and tel mw what u want to look

Tue, 16 Oct 2012 09:02:45 GMT

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

Tue, 16 Oct 2012 09:09:36 GMT

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

fdelacal — Tue, 16 Oct 2012 09:11:58 GMT

See the qvw i atach

Regardas

thomas_skariah — Tue, 16 Oct 2012 09:13:50 GMT

Hi Andrew,

You can go through the attcahed application.

Hope it works!

Regards,

Tom

Tue, 16 Oct 2012 09:14:55 GMT

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

Tue, 16 Oct 2012 10:02:29 GMT

Thanks a lot Tom !!