Using tables to multiply values like indexing or vlookup
My problem looks at different plots of land and the amount of hectares that they have. For each plot of land there is a ha value and a land type (Coastal, Farmland, Grassland, Freshwater, Mountain, Woodland, Marine and Urban).
For each of these 8 values there are another 8 different 'value' areas (i.e value from Absorbing particulates for air quality). The plot of land figure is split out by habitat type and then multiplied by the resulting value area.
Is there a way of getting Qlik to make all of these calculations for around 5000 plots of land that are separated out by?
Have attached the two formats i've put it in so far