QlikSense - Adding a column

[DGM]

Hi all!

I am totally new to Qliksense. I am using Qliksense Hub and I do not have access to  Data Script editor.

I have a report which has Employee Details. The column that interests my requirement are Employee email, Manager email. I need to add a column to this report, the manager's manager email called as Second Level Manager. Please help me out how to do this.

Any ref. to learn would be greatly appreciated.

Thanks,

DGM

[Arthur_Fong]

Maybe try referring to Qlik help to kickstart your progress.

https://help.qlik.com/en-US/sense/November2019/Content/Sense_Helpsites/Home.htm

For your enquiries, you would need to check if  Employee email and Manager email fields are available in the data model.

Open your app and click Edit button at the top right corner.

On the left panel, click Field and search for the related fields.

If the fields are available, drag the fields into the table you want to add-in as dimension.

If the fields are not available, you might need to request assistance from your development team.

[DGM]

Thank you!

I have the required fields but i am not sure how to use it in the new column.

Note:Second Manager ID is not available directly - this is what i need to include as a new dimension or measure by writing an expression.

What expression should i use in the new Dimension Column? Its kind of referring to the same table 

In Excel I would have used vLookup;

vLookup(D1, A1:D10, 4, False) - where column D has my Manager ID field and in the range specified, column A has EmployeeID.

Employee ID	Employee F Name	Employee L Name	Manager ID	Second Manager ID
DJM	Dxx	Mxx	Joe	Katy Smith
Joe	Jsdfd	Edsd	Katy Smith	Jack R
Katy Smith	Katy	Smith	Jack R	Rob

IF the Manager ID value matches the Employee ID value then the corresponding Manager ID is the Second Level Manager 

Any help to implement the same functionality here?

I am not sure if this is clear enough.

DGM