Pull data from a different table within the same sheet

[#1]

Hi All,

I have two tables in my qlikview sheet.

One of the table is completed with totals.

In the second table i need to be able to use the some data from the first table for calculations.

I need the values circled in red to calculate the value cirecled in green.

Also, the in the second table i need to be able to enter the fields under type.

Can anyone please help me with this.

Thanks in advance.

Regards.

PS. I load the data from my company server, so i do not use edit/load scipt nor any macros.

[Miguel_Angel_Baeyens]

Hi,

Did you check this? That was working for me using your example.

Regards.

[#3]

Hi,

I checked, but it doesn't work for some reason. So i was looking for a different solution.

Regards.